EX_ADV_PAST_DUE(SQL View) |
Index Back |
|---|---|
Advance Header |
| SELECT A.EMPLID ,A.ADVANCE_ID ,A.ADV_STATUS ,A.ADVANCE_NAME ,A.BUSINESS_UNIT_GL ,A.ACCOUNTING_DT ,A.BALANCE ,A.CURRENCY_CD FROM PS_EX_ADV_HDR A WHERE A.ADV_STATUS ='PST' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ADVANCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Advance ID |
| 3 | ADV_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Advance Status
APY=Approved for Payment CLS=Closed DEN=Denied DNA=Denied by Approver DNU=Denied by Auditor HDA=On Hold, with Approver HDU=On Hold, with Auditor HLD=On Hold PAR=Approvals in Process PD=Paid PND=Pending PRO=In Process PST=Past Due Balance RAP=Approved RCN=Reconciled RRT=Reroute Transaction SFA=Submission in Process STG=Staged SUB=Submitted for Approval XML=Submitted, Pending Validation |
| 4 | ADVANCE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Advance Description |
| 5 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL |
| 6 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 7 | BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Balance |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY |