ADVANCE_IDEX_CA_HDR_AW_V2(SQL View) |
Index Back |
|---|---|
Travel Auth Header ViewAdditional header information with descriptions |
| SELECT A.ADVANCE_ID , A.EMPLID , B.FIRST_NAME || ' ' || B.LAST_NAME , C.DESCR , A.REFERENCE_ID , A.ACCOUNTING_DT , A.DST_CNTRL_ID FROM PS_EX_ADV_HDR A , PS_PERSONAL_DATA B , PS_EX_PURPOSE_TBL C , PS_SET_CNTRL_REC CTL WHERE A.EMPLID = B.EMPLID AND CTL.SETCNTRLVALUE = A.BUSINESS_UNIT_GL AND CTL.RECNAME = 'EX_PURPOSE_TBL' AND CTL.SETID = C.SETID AND A.BUSINESS_PURPOSE = C.BUSINESS_PURPOSE AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_EX_PURPOSE_TBL X WHERE X.SETID = C.SETID AND X.BUSINESS_PURPOSE = C.BUSINESS_PURPOSE AND X.EFF_STATUS = 'A' AND X.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ADVANCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Advance ID |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | NAME_60 | Character(61) | VARCHAR2(61) NOT NULL | Name |
| 4 | BUS_PURP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Business Purpose |
| 5 | REFERENCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Reference ID |
| 6 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 7 | DST_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL | Accounting Template |