EX_OCONUS_TAO(SQL Table) |
Index Back |
|---|---|
OCONUS Temp TableOCONUS Temp Table ( O = Overseas) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COUNTRY_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Country |
| 3 | CITY |
Character(30) | VARCHAR2(30) NOT NULL | City |
| 4 | START_DT_JULIAN |
Number(3,0) | SMALLINT NOT NULL | Julian Start Date |
| 5 | END_DT_JULIAN |
Number(3,0) | SMALLINT NOT NULL | Julian End Date |
| 6 | CONUS_LODGING_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | CONUS Lodging Amount |
| 7 | NOGOVT_MEALS_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | No Govt Meals - CONUS |
| 8 | PROP_MEALS_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Proportion Meals Amount |
| 9 | OFF_BASE_INC_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Off Base Inc - OCONUS |
| 10 | FOOTNOTE_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Footnote Amount - OCONUS |
| 11 | FOOTNOTE_RATE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Footnote Rate - OCONUS |
| 12 | STD_PER_DIEM_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Standard Per Diem Amount |
| 13 | START_OF_SEASON | Character(5) | VARCHAR2(5) NOT NULL | Start of Season |
| 14 | END_OF_SEASON | Character(5) | VARCHAR2(5) NOT NULL | End of Season |
| 15 | RPT_DT | Date(10) | DATE | Report Date |
| 16 | DATA_SOURCE_EX | Character(3) | VARCHAR2(3) NOT NULL |
External Data Sources for PS Expenses
AIR=Airline Ticket AMA=American Express AMG=American Express AMH=American Express-Hotel Folio AMM=American Express - Member List AMX=American Express CNS=CONUS DC=Diners Club IPH=iReceipts MC=MasterCard CDFv2 MCX=MasterCard CDFv3 MSG=Text Message NAP=PS NA Payroll PDA=PDA RNZ=Runzheimer SAB=Sabre UBT=User Chatbot USB=US Bank USR=User Input VI4=Visa VIS=Visa |