SSR_APT_REQ_RN3(SQL Table) |
Index Back |
|---|---|
APT Request Runcntl childAPT Request Runcntl child record to capture the custom input |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID |
| 3 | SSR_NODE_ID |
Number(4,0) | SMALLINT NOT NULL |
Planning Node
Prompt Table: SSR_PRGFRM_PLND |
| 4 | SSR_ATT_STAT |
Character(2) | VARCHAR2(2) NOT NULL |
Attempt Status
20=Activated 60=Provisional 80=Finalized |
| 5 | SSR_ATT_OUTCOME |
Character(4) | VARCHAR2(4) NOT NULL |
Attempt Outcome
20=Not Passed 40=Passed |
| 6 | SSR_APT_ACT_MODE | Character(4) | VARCHAR2(4) NOT NULL |
APT Request Action
CRPN=Create Plan Node NEWA=New Attempt NXTP=Next Planning Node |