BI_FFEXT_AET(SQL Table) |
Index Back |
|---|---|
Federal Hwy Extract State RecThe state record for the Federal Highway Extract File process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 4 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 5 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 6 | DATE_BATCH | Character(8) | VARCHAR2(8) NOT NULL | Date represented in string format as MMDDYYYY used on batch files. |
| 7 | BATCH_DATE | Date(10) | DATE | Batch Date |
| 8 | BATCH_DATE_X | Character(10) | VARCHAR2(10) NOT NULL | Batch Date |
| 9 | TGT_PYMT_DATE_X | Character(10) | VARCHAR2(10) NOT NULL | Target Payment Date |
| 10 | EXPENDITURE_AMT | Character(11) | VARCHAR2(11) NOT NULL | Expenditure Amount on the Federal Highway File - string format |
| 11 | FEDERAL_APPROP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
An indicator to specify which PC Chartfield is used to store the Federal Appropriation Number.
C=Category N=None S=SubCategory T=Source Type |
| 12 | FEDERAL_PROJ_FLG | Character(1) | VARCHAR2(1) NOT NULL |
An indicator to specify which PC Chartfield is used to store the Federal Appropriation Number.
C=Contract Number N=None P=Project ID |
| 13 | DEMO_ID_FLG | Character(1) | VARCHAR2(1) NOT NULL |
An indicator to specify which PC Chartfield is used to store the Federal Demo ID.
C=Category N=None S=SubCategory T=Source Type |
| 14 | SUMMARIZE_IVC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Summarize Invoice Flag |
| 15 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 16 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
| 17 | FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL | Fieldname 2 |
| 18 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 19 | FINAL_RUN_IND | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates the final run of the federal highway extract file creation.
Y/N Table Edit |
| 20 | FNL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether billing status of Finalized should be included on the federal highway extract file.
Y/N Table Edit |
| 21 | HOLD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Hold From Further Processing
Y/N Table Edit |
| 22 | INV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether billing status of Invoiced should be included on the federal highway extract file.
Y/N Table Edit |
| 23 | NET_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amt |
| 24 | TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount |
| 25 | NEW_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether billing status of New should be included on the federal highway extract file.
Y/N Table Edit |
| 26 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 27 | PEND_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether billing status of Pending should be included on the federal highway extract file.
Y/N Table Edit |
| 28 | FED_APPROPRIATION | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 29 | FED_AGREE_CODE | Character(25) | VARCHAR2(25) NOT NULL | Federal Agreement Number - may be the Contract Number |
| 30 | DEMO_ID | Character(5) | VARCHAR2(5) NOT NULL | Federal Demo ID |
| 31 | READY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether billing status of Ready should be included on the federal highway extract file.
Y/N Table Edit |
| 32 | RECREATE_FILE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether the federal highway extract file is to be recreated.
Y/N Table Edit |
| 33 | REGION_CODE | Character(2) | VARCHAR2(2) NOT NULL | Region Code identifies a specific region within a State. |
| 34 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 35 | STATE_US_NBR | Number(2,0) | SMALLINT NOT NULL | Numeric 2 position US state code. |
| 36 | TARGET_PYMT_DT | Date(10) | DATE |
The Target Payment Date on the final run of the Federal Highway Extract File process for an invoice.
Default Value: %Date |
| 37 | TMP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether billing status of Temporary should be included on the federal highway extract file.
Y/N Table Edit |
| 38 | TMR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether billing status of Temporary Ready should be included on the federal highway extract file.
Y/N Table Edit |
| 39 | TOTAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Amount |
| 40 | WHERE_CLAUSE_LONG | Long Character(4000) | CLOB | Where Clause |
| 41 | FED_REGION_CD_INST | Character(2) | VARCHAR2(2) NOT NULL | Region Code identifies a specific region within a State. |