FISCAL_YEARGL_FACTSI_DEPTBUREAUFUND_GROUPGL_FACTSI_ACCTTSYMBOL_ATTRIBSECTOR_TYPEINTDEPT_CDEXOMB_FUNCTIONCUST_OPTIONN=Natural
R=Reversal
FACTSI_STG(SQL Table) |
Index Back |
|---|---|
FACTS I staging tableThis table stores data generated by the GL_FACTSI App Engine process |
| # | 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 | TSYMBOL_ATTRIB |
Character(16) | VARCHAR2(16) NOT NULL | Treasury Symbol Attribute |
| 7 | SECTOR_TYPE |
Character(1) | VARCHAR2(1) NOT NULL | FACTS I Sector Type |
| 8 | INTDEPT_CD |
Character(2) | VARCHAR2(2) NOT NULL | FACTS I Interdepartment Code |
| 9 | EX |
Character(1) | VARCHAR2(1) NOT NULL | Expenses |
| 10 | OMB_FUNCTION |
Character(3) | VARCHAR2(3) NOT NULL | Function |
| 11 | CUST_OPTION |
Character(1) | VARCHAR2(1) NOT NULL | Customer Option |
| 12 | 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 |
| 13 | 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. |
| 14 | STORE_NUMBER | Character(17) | VARCHAR2(17) NOT NULL | Store Number |
| 15 | VALUE1 | Character(1) | VARCHAR2(1) NOT NULL | VALUE1 |
| 16 | VALUE2 | Character(1) | VARCHAR2(1) NOT NULL | VALUE2 |
| 17 | VALUE3 | Character(1) | VARCHAR2(1) NOT NULL | VALUE3 |
| 18 | BEGIN_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Beginning Balance |
| 19 | POSTED_TOTAL_DR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Posted Total Debits |
| 20 | POSTED_TOTAL_CR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Posted Total Credits |
| 21 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |