GTAS_STG_DTL_VW

(SQL View)
 Index Back

GTAS Staging Detail View


SELECT A.BUSINESS_UNIT ,A.TAS_GWA , A.REPORT_ID , A.ACCOUNT , A.ALTACCT , %subrec(CF9B_AK_SBR,A) , A.PROJECT_ID ,A.DEPTID ,A.FISCAL_YEAR ,A.ACCOUNTING_PERIOD ,A.GTAS_BEGIN_END ,A.GTAS_ACCOUNT , A.BUDG_PROP , A.ANTICIPATED , A.FED_NONFED , A.TRAD_PARTNER , A.TRAD_MAIN_ACCOUNT , A.EXCHANGE , A.CUSTODIAL , A.GTAS_AUTH_TYPE , A.GTAS_APPOR_CAT_CD , A.GTAS_CAT_B_CD , A.GTAS_PROG_CD , A.YEAR_BUDGET_AUTH , A.AVAIL_TIME , A.BEA_CATEGORY_IND , A.GTAS_BORROW_SOURCE , A.PY_ADJUST , A.GTAS_REIMBURSE_IND , A.GTAS_BUDG_IMPACT , A.PROG_IND , A.GTAS_COHORT_YR , A.GTAS_DEBIT_CREDIT , A.REDUCTION_TYPE , A.FED_DEFC , A.FED_BOC , A.BEGIN_BALANCE , A.PTD_AMOUNT , A.CURRENCY_CD , A.POSTED_TOTAL_DR , A.POSTED_TOTAL_CR , A.POSTED_TOTAL_AMT , A.RECORD_TYPE_7 FROM PS_GTAS_STG_DTL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
5 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
6 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPER_UNIT_TBL

7 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_TBL

8 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_TBL

9 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASS_CF_TBL

10 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_TBL

11 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_TBL

12 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

13 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

14 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

15 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CHARTFIELD1_TBL

16 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CHARTFIELD2_TBL

17 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CHARTFIELD3_TBL

18 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
19 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
20 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
21 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.
22 GTAS_BEGIN_END Character(1) VARCHAR2(1) NOT NULL Beginning/Ending Bal Indicator
B=Beginning Balances
E=Ending Balances
23 GTAS_ACCOUNT Character(6) VARCHAR2(6) NOT NULL GTAS Account
24 BUDG_PROP Character(1) VARCHAR2(1) NOT NULL Budgetary/Proprietary
25 ANTICIPATED Character(1) VARCHAR2(1) NOT NULL Anticipated
26 FED_NONFED Character(1) VARCHAR2(1) NOT NULL Federal NonFederal Code
27 TRAD_PARTNER Character(3) VARCHAR2(3) NOT NULL Trading Partner Agency Code
28 TRAD_MAIN_ACCOUNT Character(4) VARCHAR2(4) NOT NULL Trading Partner Main Account
29 EXCHANGE Character(1) VARCHAR2(1) NOT NULL Exchange Non Exchange Code
30 CUSTODIAL Character(1) VARCHAR2(1) NOT NULL Custodial
31 GTAS_AUTH_TYPE Character(1) VARCHAR2(1) NOT NULL Authority Type
32 GTAS_APPOR_CAT_CD Character(1) VARCHAR2(1) NOT NULL Apportionment Category Code
33 GTAS_CAT_B_CD Character(4) VARCHAR2(4) NOT NULL GTAS Category B Program Code
34 GTAS_PROG_CD Character(2) VARCHAR2(2) NOT NULL GTAS Program Report Catg Code
35 YEAR_BUDGET_AUTH Character(4) VARCHAR2(4) NOT NULL Year of Budget Authority
36 AVAIL_TIME Character(1) VARCHAR2(1) NOT NULL Availability Time Indicator
37 BEA_CATEGORY_IND Character(1) VARCHAR2(1) NOT NULL BEA Category Indicator
38 GTAS_BORROW_SOURCE Character(1) VARCHAR2(1) NOT NULL Borrowing Source
39 PY_ADJUST Character(1) VARCHAR2(1) NOT NULL Prior Year Adjustment Code
40 GTAS_REIMBURSE_IND Character(1) VARCHAR2(1) NOT NULL Reimbursable Ind
41 GTAS_BUDG_IMPACT Character(1) VARCHAR2(1) NOT NULL Deny
42 PROG_IND Character(1) VARCHAR2(1) NOT NULL Deny
43 GTAS_COHORT_YR Character(4) VARCHAR2(4) NOT NULL Credit Cohort Year
44 GTAS_DEBIT_CREDIT Character(1) VARCHAR2(1) NOT NULL Debit / Credit Indicator
45 REDUCTION_TYPE Character(3) VARCHAR2(3) NOT NULL Reduction Type Code
46 FED_DEFC Character(3) VARCHAR2(3) NOT NULL Disaster Emergency Fund Code
47 FED_BOC Character(4) VARCHAR2(4) NOT NULL GTAS Budget Object Class
48 BEGIN_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Beginning Balance
49 PTD_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Period to Date Amount
50 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
51 POSTED_TOTAL_DR Signed Number(28,3) DECIMAL(26,3) NOT NULL Posted Total Debits
52 POSTED_TOTAL_CR Signed Number(28,3) DECIMAL(26,3) NOT NULL Posted Total Credits
53 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.
54 RECORD_TYPE_7 Character(15) VARCHAR2(15) NOT NULL Record Type 7 TAS