DATA_C_BAL_TBL

(SQL Table)
Index Back

Data Act File C Balance Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
2 TAS_GWA Character(26) VARCHAR2(26) NOT NULL TAS GWA
3 REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier
4 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
5 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
7 FED_ACCOUNT Character(6) VARCHAR2(6) NOT NULL FED account for OMB
8 PROCURE_INSTRUM_ID Character(50) VARCHAR2(50) NOT NULL Procurement Instrument ID
9 PI_ID_PARENT Character(50) VARCHAR2(50) NOT NULL Parent PIID
10 FEDERAL_AWARD_ID Character(30) VARCHAR2(30) NOT NULL Federal Award IdentificationNo
11 UNIVERSAL_REC_ID Character(70) VARCHAR2(70) NOT NULL Universal Record Identifier
12 GTAS_REIMBURSE_IND Character(1) VARCHAR2(1) NOT NULL Reimbursable Ind
13 FED_PROGRAM Character(4) VARCHAR2(4) NOT NULL Fed Program Code
14 FED_CLASS_FLD Character(4) VARCHAR2(4) NOT NULL Fed Class Field code
15 FED_DEFC Character(3) VARCHAR2(3) NOT NULL Disaster Emergency Fund Code
16 FED_MAP_EFFDT Date(10) DATE Effective date
17 PRIORITY_ORDER Number(5,0) INTEGER NOT NULL Priority Order for Schedules
18 DESCR240 Character(240) VARCHAR2(240) NOT NULL Description
19 PTD_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Period to Date Amount
20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code