SHEET_IDSEQ_NUMADJ=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_HISTORY(SQL Table) |
Index Back |
|---|---|
Expense HistoryExpense History |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 2 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 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 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display |
| 5 | ROW_CREATE_DATE | DateTime(26) | TIMESTAMP | Row Creation Date Time |
| 6 | REASON_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Reason Type |
| 7 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 8 | COMMENTS | Long Character | CLOB | Comment |