RTBL_ALLOC_CF

(SQL Table)
 Index Back

RTBL Allocation Chartfields

RTBL Allocation Chartfields details

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
5 PROCESS_STEP Character(10) VARCHAR2(10) NOT NULL Process Step
6 PROCESS_BEGIN Number(10,0) DECIMAL(10) NOT NULL Begin Process Instance
7 PROCESS_END Number(10,0) DECIMAL(10) NOT NULL End Process Instance
8 SELECT_CHKBOX1 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes
9 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPER_UNIT_TBL

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

Prompt Table: PRODUCT_TBL

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

Prompt Table: FUND_TBL

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

Prompt Table: CLASS_CF_TBL

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

Prompt Table: PROGRAM_TBL

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

Prompt Table: BUD_REF_TBL

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CHARTFIELD1_TBL

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

Prompt Table: CHARTFIELD2_TBL

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

Prompt Table: CHARTFIELD3_TBL

21 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
22 SELECT_CHKBOX2 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes
23 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
24 SELECT_CHKBOX3 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes
25 SELECT_CHKBOX4 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes
26 SELECT_CHKBOX5 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes
27 SELECT_CHKBOX6 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes
28 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
29 SELECT_CHKBOX7 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
30 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
31 SELECT_CHKBOX8 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
32 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code
33 SELECT_CHKBOX9 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
34 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period
35 SELECT_CHKBOX10 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
36 SELECT_CHKBOX11 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
37 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
38 SELECT_CHKBOX12 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
39 SELECT_CHKBOX13 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
40 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
41 SELECT_CHKBOX14 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
42 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
43 SELECT_CHKBOX15 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
44 SELECT_CHKBOX16 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
45 GL_ADJUST_TYPE Character(4) VARCHAR2(4) NOT NULL Adjustment Type
46 SELECT_CHKBOX17 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
47 SELECT_CHKBOX18 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
48 SELECT_CHKBOX19 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
49 SELECT_CHKBOX20 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
50 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
51 SELECT_CHKBOX21 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
52 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
53 SELECT_CHKBOX22 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
54 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
55 SELECT_CHKBOX23 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
56 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
57 SELECT_CHKBOX24 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
58 SCENARIO Character(10) VARCHAR2(10) NOT NULL A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca
59 SELECT_CHKBOX25 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
60 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
61 DATE_CHAR Character(26) VARCHAR2(26) NOT NULL Generic space field
62 TIMESTAMPFIELDNAME Character(18) VARCHAR2(18) NOT NULL Row Level TimeStamp Field Name
63 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID
64 RTBL_SCENARIO Character(18) VARCHAR2(18) NOT NULL Scenario Name