DEPT_ACCESS_TBL

index back

Tree Nodes


PeopleSoft Field NameField TypeColumn TypeDescription
SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID
TREE_NODECharacter(20)VARCHAR2(20) NOT NULLNode name
EFFDTDate(10)DATEEffective Date

Default: DEPT_NODE_TBL.EFFDT

SEQNUMNumber(3,0)SMALLINT NOT NULLSequence Number
EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
A=Active
I=Inactive

Default: A

EMAILIDCharacter(70)VARCHAR2(70) NOT NULLA user's E-mail address
DISTIDCharacter(30)VARCHAR2(30) NOT NULLDistribution ID

Prompt Table: %EDITTABLE

DISTIDTYPECharacter(3)VARCHAR2(3) NOT NULLDistribution ID Type
2=User ID
3=Role Name

Default: 2

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19