EX_APR_STAT_VW(SQL View) |
Index Back |
|---|
| SELECT '' ,'' ,'' ,'' ,'' ,0 ,'' ,'' ,%DateNull ,'' ,'' FROM %Table(INSTALLATION) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 2 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 3 | APPROVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Approver Oprid |
| 4 | APPROVER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Approver |
| 5 | APPROVER_PROFILE | Character(15) | VARCHAR2(15) NOT NULL | Approver profile name |
| 6 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | EOAWSTEP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Step Instance Status
A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial |
| 9 | ACTION_DTTM | DateTime(26) | TIMESTAMP | Override Date Time |
| 10 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 11 | COMMENTS | Long Character | CLOB | Comment |