SDK_DEPT_TBL_VW

index back

SDK Department Table View

SDK Department Table View
SELECT SDK_DEPTID ,SDK_EFFDT ,SDK_DESCR ,SDK_DESCRSHORT FROM PS_SDK_DEPT_TBL WHERE SDK_DEPTID < '20000'

PeopleSoft Field NameField TypeColumn TypeDescription
SDK_DEPTIDCharacter(10)VARCHAR2(10) NOT NULLSDK Department ID
SDK_EFFDTDate(10)DATE NOT NULLSDK Effective Date

Default: %date

SDK_DESCRCharacter(30)VARCHAR2(30) NOT NULLSDK Description
SDK_DESCRSHORTCharacter(10)VARCHAR2(10) NOT NULLSDK Short Description
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19