SDK_OPRIDPrompt Table: PSOPRDEFN
SDK_DEPTIDN=No Access
Y=Read/Write Access
SDK_SCRTY_DEPT(SQL Table) |
Index Back |
|---|---|
SDK User Access to DepartmentsSDK User Access to Departments |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SDK_OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
SDK Operator ID
Prompt Table: PSOPRDEFN |
| 2 | SDK_DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | SDK Department ID |
| 3 | SDK_ACCESS_CD | Character(1) | VARCHAR2(1) NOT NULL |
SDK Access Code
N=No Access Y=Read/Write Access |
| 4 | SDK_TREE_EFFDT | Date(10) | DATE NOT NULL | SDK Effective Date Of Tree |
| 5 | SDK_TREE_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | SDK Tree Node Number - Internal beginning node range number |
| 6 | SDK_TREE_NODE_END | Number(10,0) | DECIMAL(10) NOT NULL | SDK Tree Node Number End - Internal ending node range number |