TREE_LEVEL_BUVW

index back

Sample/Default Tree Level Tbl


SELECT SETID ,TREE_LEVEL ,EFFDT ,EFF_STATUS ,DESCR ,DESCRSHORT ,SETID FROM PS_TREE_LEVEL_TBL

PeopleSoft Field NameField TypeColumn TypeDescription
SETCNTRLVALUECharacter(20)VARCHAR2(20) NOT NULLTree Definition User Key Value
TREE_LEVELCharacter(10)VARCHAR2(10) NOT NULLTree Level Number
EFFDTDate(10)DATE NOT NULLEffective Date

Default: %date

EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
A=Active
I=Inactive

Default: A

DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
DESCRSHORTCharacter(10)VARCHAR2(10) NOT NULLShort Description
SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19