EORD_DEL_SETPrompt Table: OPRID_VW
C=Complete Delete
P=Partial Delete
R=Registered
U=Unregistered
C=Created
I=Submitted
P=Completed
N=Exclude locked users
Y=Include Locked Users
Default Value: Y
EORD_DELSET_H(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EORD_DEL_SET |
Character(18) | VARCHAR2(18) NOT NULL | Delete Request |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | EORD_DELOPT | Character(1) | VARCHAR2(1) NOT NULL |
Delete Option
C=Complete Delete P=Partial Delete |
| 5 | GL_RCM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
R=Registered U=Unregistered |
| 6 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 7 | DATETIME_CREATED | DateTime(26) | TIMESTAMP | DateTime Created |
| 8 | DATETIME_UPDATED | DateTime(26) | TIMESTAMP | DateTime Updated |
| 9 | EORD_PRC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
C=Created I=Submitted P=Completed |
| 10 | EORD_USRLCK | Character(1) | VARCHAR2(1) NOT NULL |
Include Account Locked Users
N=Exclude locked users Y=Include Locked Users Default Value: Y |