SDK_SCRTY_DEPT

index back

SDK User Access to Departments

SDK User Access to Departments

PeopleSoft Field Name Field Type Column Type Description
SDK_OPRID Character(30) VARCHAR2(30) NOT NULL SDK Operator ID

Prompt Table: PSOPRDEFN

SDK_DEPTID Character(10) VARCHAR2(10) NOT NULL SDK Department ID
SDK_ACCESS_CD Character(1) VARCHAR2(1) NOT NULL SDK Access Code
N=No Access
Y=Read/Write Access
SDK_TREE_EFFDT Date(10) DATE NOT NULL SDK Effective Date Of Tree
SDK_TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL SDK Tree Node Number - Internal beginning node range number
SDK_TREE_NODE_END Number(10,0) DECIMAL(10) NOT NULL SDK Tree Node Number End - Internal ending node range number
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19