PJB_SF270_REPORT_HISTORY
PJB_SF270_REPORT_HISTORY stores the history of SF270, which is a financial status report for a federal award contract.
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REPORT_ID | NUMBER | 18 | Yes | Standard PK | |
| STATUS_CODE_FLAG | VARCHAR2 | 1 | Yes | Report approval status. O indicates Original, D indicates Draft and P published. | |
| CONTRACT_ID | NUMBER | 18 | Yes | Award Contract identification number. Identifies award contract for which this report is generated | |
| MAJOR_VERSION | NUMBER | 18 | Yes | Version Number of contract. | |
| PAYMENT_REQ_NUMBER | NUMBER | 18 | Yes | Payment request number for the contract award which is a sequence number. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| RUN_DATE | DATE | Yes | Date report run | ||
| ACCOUNTING_BASIS_FLAG | VARCHAR2 | 1 | Yes | Accounting basis used for report. Valid values include A for Accrual and C for Cash. | |
| PAYMENT_TYPE_FLAG | VARCHAR2 | 1 | Yes | Payment types include advance or reimbursement. | |
| PAYMENT_SCHEDULE_FLAG | VARCHAR2 | 1 | Yes | Payment schedules are final or partial. | |
| SPONSOR_ID | NUMBER | 18 | Identifier of the Federal sponsoring agency to which the report is submitted. | ||
| FEDERAL_GRANT_NUMBER | VARCHAR2 | 30 | Federal Grant or other identifying number assigned by Federal Agency | ||
| EMPLOYER_NUMBER | VARCHAR2 | 30 | Registration number against a tax regime | ||
| RECIPIENT_ACCT_NUMBER | VARCHAR2 | 120 | Award/Contract number assigned by the receiving institution doing the billing. | ||
| REPORT_START_DATE | DATE | Start date of the report | |||
| REPORT_END_DATE | DATE | End date of the report | |||
| TOTAL_PRG_AMT | NUMBER | Total cost from award contract start date to Report end date. | |||
| TOTAL_FED_AMT | NUMBER | Total Federal cost from award contract start date to Report end date. | |||
| TOTAL_PREVIOUS_FED_AMT | NUMBER | Sum of previous federal amount of the Published reports for the Contract Award. | |||
| TOTAL_NON_FED_AMT | NUMBER | Total Non Federal cost from award contract start date to Report end date. | |||
| CURRENT_FED_AMT | NUMBER | Federal amount requested in current run. | |||
| CURRENCY_CODE | VARCHAR2 | 30 | Contract ledger currency code | ||
| RECIPIENT_INSTITUTION_ID | NUMBER | 18 | Recipient organization Identifier | ||
| RECIPIENT_ADDRESS_ID | NUMBER | 18 | Recipient Organization address identifier | ||
| BU_ID | NUMBER | 18 | Yes | Award contract business unit id | |
| PAYEE_NAME | VARCHAR2 | 240 | Payee name | ||
| PAYEE_ADDRESS | VARCHAR2 | 240 | Payee Address, to which checks need to be sent. Stores Number and Street details. | ||
| PAYEE_CITY_STATE_ZIP | VARCHAR2 | 240 | Payee city,state and zip. | ||
| REMARKS | VARCHAR2 | 1000 | Remarks or special notes for this report | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CUMULATIVE_PRG_AMT | NUMBER | Cumulative Program income | |||
| ESTIMATED_NET_CASH_AMT | NUMBER | Estimated net cash outlays for advanced period | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| INVOICE_ID | NUMBER | 18 | Yes | Identifier of the Invoice that corresponds to SF270 report. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJB_SF270_REPORT_HISTORY | okc_k_headers_all_b | CONTRACT_ID, MAJOR_VERSION |
| PJB_SF270_REPORT_HISTORY | gms_sponsors_b | SPONSOR_ID |
| PJB_SF270_REPORT_HISTORY | gms_institutions_b | RECIPIENT_INSTITUTION_ID |
| PJB_SF270_REPORT_HISTORY | pjb_invoice_headers | INVOICE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_SF270_REPORT_HISTORY_U1 | Unique | FUSION_TS_TX_DATA | REPORT_ID, STATUS_CODE_FLAG |
| PJB_SF270_REPORT_HISTORY_U2 | Unique | FUSION_TS_TX_DATA | CONTRACT_ID, PAYMENT_REQ_NUMBER, STATUS_CODE_FLAG |