LED_FACTSI2_TAO(SQL Table) |
Index Back |
|---|---|
FACTS I Generation Temp Tbl 2This temp table stores consolidated data from the LED_FACTSI_TAO temp table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 2 | GL_FACTSI_DEPT | Character(2) | VARCHAR2(2) NOT NULL | FACTS I Department Code - needed for FACTS I flat-file submission |
| 3 | BUREAU | Character(2) | VARCHAR2(2) NOT NULL | FACTS I Bureau |
| 4 | FUND_GROUP | Character(4) | VARCHAR2(4) NOT NULL | FACTS I Fund Group |
| 5 | GL_FACTSI_ACCT | Character(4) | VARCHAR2(4) NOT NULL | FACTS I Account |
| 6 | SECTOR_TYPE | Character(1) | VARCHAR2(1) NOT NULL | FACTS I Sector Type |
| 7 | INTDEPT_CD | Character(2) | VARCHAR2(2) NOT NULL | FACTS I Interdepartment Code |
| 8 | MOVEMENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign.
N=Natural R=Reversal |
| 9 | POSTED_TOTAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination. |
| 10 | STORE_NUMBER | Character(17) | VARCHAR2(17) NOT NULL | Store Number |
| 11 | VALUE1 | Character(1) | VARCHAR2(1) NOT NULL | VALUE1 |
| 12 | EX | Character(1) | VARCHAR2(1) NOT NULL | Expenses |
| 13 | VALUE2 | Character(1) | VARCHAR2(1) NOT NULL | VALUE2 |
| 14 | OMB_FUNCTION | Character(3) | VARCHAR2(3) NOT NULL | Function |
| 15 | VALUE3 | Character(1) | VARCHAR2(1) NOT NULL | VALUE3 |
| 16 | CUST_OPTION | Character(1) | VARCHAR2(1) NOT NULL | Customer Option |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |