MADE_RPT_TBL(SQL Table) |
Index Back |
|---|---|
Table for FRA MADE ReportTable for Federal MADE Report |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_CA_NONVW |
| 5 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 6 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 7 | CHG_ID | Character(10) | VARCHAR2(10) NOT NULL | Change Package Identifier. This is sequenced from 1 to N for each contract. |
| 8 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 9 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 10 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 11 | END_DATE | Date(10) | DATE | End Date |
| 12 | SD_TEXT4_5 | Character(4) | VARCHAR2(4) NOT NULL | Text |
| 13 | SD_TEXT4_1 | Character(4) | VARCHAR2(4) NOT NULL | Text |
| 14 | SD_TEXT4_2 | Character(4) | VARCHAR2(4) NOT NULL | Text |
| 15 | REVISED_GROSS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Negotiated Amount |
| 16 | EARNED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Earned Amount |
| 17 | BILL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
| 18 | COLLECTED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Collected Amount |
| 19 | ADVANCED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Advanced Amount |
| 20 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 21 | CHG_ID_SRCH | Character(10) | VARCHAR2(10) NOT NULL | Search Change ID. |
| 22 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 23 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 24 | START_DT | Date(10) | DATE | Start Date |
| 25 | END_DT | Date(10) | DATE | End Date |
| 26 | SD_TEXT4_3 | Character(4) | VARCHAR2(4) NOT NULL | Text |
| 27 | SD_TEXT4_4 | Character(4) | VARCHAR2(4) NOT NULL | Text |
| 28 | CA_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Obligation status
A=Active C=Cancelled P=Pending R=Renewed |
| 29 | CA_DELIVERY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Contracts Delivery Status
F=Final Delivery P=Partial Delivery U=Undelivered |
| 30 | LIMIT_AMT_BIL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Funded/Billing Limit Amount |
| 31 | TAS_GWA | Character(26) | VARCHAR2(26) NOT NULL | TAS GWA |
| 32 | BETC_CD | Character(8) | VARCHAR2(8) NOT NULL | Business Event Type Code |
| 33 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |