SDK_OPRIDPrompt Table: PSOPRDEFN
SDK_DEPTIDN=No Access
Y=Read/Write Access
SDK_SCRTY_DEPT |
index back |
|---|---|
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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |