PROCESS_INSTANCEADJ=Adjusted
APY=Approved for Payment
APZ=Approved for zero Payment
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Auditor
OPN=Open
PD=Paid
PND=Pending
RAP=Approved
SUB=Submitted
SPA_EXP_UPD_AET(SQL Table) |
Index Back |
|---|---|
Update Expense AE state recordUpdate Expense AE state record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 3 | EXP_HDR_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Expense Header Status
ADJ=Adjusted APY=Approved for Payment APZ=Approved for zero Payment DEN=Denied DNA=Denied by Approver DNU=Denied by Auditor OPN=Open PD=Paid PND=Pending RAP=Approved SUB=Submitted |
| 4 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display |
| 6 | ROW_CREATE_DATE | DateTime(26) | TIMESTAMP | Row Creation Date Time |
| 7 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 8 | REASON_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Reason Type |
| 9 | COMMENTS | Long Character | CLOB | Comment |