RTBL_ALLOC_VW

(SQL View)
Index Back

RTBL Allocation Calc View

RTBL Allocation Calculations Log View

SELECT C.PROCESS_INSTANCE , A.PROCESS_INSTANCE , C.RUN_CNTL_ID , C.OPRID , C.SETID , C.PROCESS_STEP , C.PROCESS_BEGIN , C.PROCESS_END , C.DATE_CHAR , C.TIMESTAMPFIELDNAME , A.PROCESS_STEP , A.SEQ_NBR , A.BUSINESS_UNIT , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.ALLOC_POOL_AMT , A.ALLOC_POOL_PBA , A.ALLOC_POOL_PTR , A.ALLOC_BASIS_AMT , A.ALLOC_BASIS_TOT , A.ALLOC_TARG_OFF_AMT , A.ALLOC_TARG_OFF_PBA , A.ALLOC_TARG_OFF_PTR , A.LOGICAL_RECORD , C.SELECT_CHKBOX3 , C.SELECT_CHKBOX4 , C.SELECT_CHKBOX5 , C.SELECT_CHKBOX6 , C.SELECT_CHKBOX2 , C.SELECT_CHKBOX1 , C.SELECT_CHKBOX7 , C.SELECT_CHKBOX8 , C.SELECT_CHKBOX9 , C.SELECT_CHKBOX10 , C.SELECT_CHKBOX11 , C.SELECT_CHKBOX12 , C.SELECT_CHKBOX13 , C.SELECT_CHKBOX14 , C.SELECT_CHKBOX15 , C.SELECT_CHKBOX16 , C.SELECT_CHKBOX17 , C.SELECT_CHKBOX18 , C.SELECT_CHKBOX19 , C.SELECT_CHKBOX20 , C.SELECT_CHKBOX21 , C.SELECT_CHKBOX22 , C.SELECT_CHKBOX23 , C.SELECT_CHKBOX24 , C.SELECT_CHKBOX25 , CASE WHEN ( C.SELECT_CHKBOX1)= 'N' THEN ' ' ELSE A.ACCOUNT END , CASE WHEN ( C.SELECT_CHKBOX6)= 'N' THEN ' ' ELSE A.ALTACCT END , CASE WHEN ( C.SELECT_CHKBOX14)= 'N' THEN ' ' ELSE A.DEPTID END , CASE WHEN ( C.SELECT_CHKBOX17)= 'N' THEN ' ' ELSE %Sql(OPERATING_UNIT,A.) END , CASE WHEN ( C.SELECT_CHKBOX18)= 'N' THEN ' ' ELSE %Sql(PRODUCT,A.) END , CASE WHEN ( C.SELECT_CHKBOX15)= 'N' THEN ' ' ELSE %Sql(FUND_CODE,A.) END , CASE WHEN ( C.SELECT_CHKBOX12)= 'N' THEN ' ' ELSE %Sql(CLASS_FLD,A.) END , CASE WHEN ( C.SELECT_CHKBOX19)= 'N' THEN ' ' ELSE %Sql(PROGRAM_CODE,A.) END , CASE WHEN ( C.SELECT_CHKBOX10)= 'N' THEN ' ' ELSE %Sql(BUDGET_REF,A.) END , CASE WHEN ( C.SELECT_CHKBOX3)= 'N' THEN ' ' ELSE %Sql(AFFILIATE,A.) END , CASE WHEN ( C.SELECT_CHKBOX4)= 'N' THEN ' ' ELSE %Sql(AFFILIATE_INTRA1,A.) END , CASE WHEN ( C.SELECT_CHKBOX5)= 'N' THEN ' ' ELSE %Sql(AFFILIATE_INTRA2,A.) END ,%Sql(CHARTFIELD1,A.) ,%Sql(CHARTFIELD2,A.) ,%Sql(CHARTFIELD3,A.) , CASE WHEN ( C.SELECT_CHKBOX11)= 'N' THEN ' ' ELSE A.BUSINESS_UNIT_PC END , CASE WHEN ( C.SELECT_CHKBOX20)= 'N' THEN ' ' ELSE A.PROJECT_ID END , CASE WHEN ( C.SELECT_CHKBOX2)= 'N' THEN ' ' ELSE A.ACTIVITY_ID END , CASE WHEN ( C.SELECT_CHKBOX23)= 'N' THEN ' ' ELSE A.RESOURCE_TYPE END , CASE WHEN ( C.SELECT_CHKBOX9)= 'N' THEN ' ' ELSE A.BUDGET_PERIOD END , CASE WHEN ( C.SELECT_CHKBOX24)= 'N' THEN ' ' ELSE A.SCENARIO END , CASE WHEN ( C.SELECT_CHKBOX8)= 'N' THEN ' ' ELSE A.BOOK_CODE END , CASE WHEN ( C.SELECT_CHKBOX16)= 'N' THEN ' ' ELSE A.GL_ADJUST_TYPE END , CASE WHEN ( C.SELECT_CHKBOX7)= 'N' THEN ' ' ELSE A.ANALYSIS_TYPE END , CASE WHEN ( C.SELECT_CHKBOX22)= 'N' THEN ' ' ELSE A.RESOURCE_SUB_CAT END , CASE WHEN ( C.SELECT_CHKBOX21)= 'N' THEN ' ' ELSE A.RESOURCE_CATEGORY END , CASE WHEN ( C.SELECT_CHKBOX13)= 'N' THEN ' ' ELSE A.CURRENCY_CD END , CASE WHEN ( C.SELECT_CHKBOX25)= 'N' THEN ' ' ELSE A.STATISTICS_CODE END , A.FOREIGN_CURRENCY , A.CURRENCY_CD , C.SCE_ID , C.RTBL_SCENARIO FROM PS_ALLOC_CALC_LOG A , ( SELECT DISTINCT A.SETID , A.PROCESS_STEP , A.EFFDT , A.DESCR FROM PS_ALLOC_STEP_TBL A WHERE A.BUDGET_COPY = 'N' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ALLOC_STEP_TBL WHERE SETID = A.SETID AND PROCESS_STEP = A.PROCESS_STEP )) B , PS_RTBL_ALLOC_CF C WHERE ( B.PROCESS_STEP = A.PROCESS_STEP AND B.SETID = C.SETID AND A.PROCESS_INSTANCE BETWEEN C.PROCESS_BEGIN AND C.PROCESS_END AND (( A.ACCOUNT <> ' ' AND A.ACCOUNT = C.ACCOUNT) OR C.ACCOUNT = ' ') AND (( A.ALTACCT <> ' ' AND A.ALTACCT = C.ALTACCT) OR C.ALTACCT = ' ') AND (( A.DEPTID <> ' ' AND A.DEPTID = C.DEPTID) OR C.DEPTID = ' ') AND (( %Sql(OPERATING_UNIT,A.) <> ' ' AND %Sql(OPERATING_UNIT,A.) = %Sql(OPERATING_UNIT,C.)) OR %Sql(OPERATING_UNIT,C.) = ' ') AND (( %Sql(PRODUCT,A.) <> ' ' AND %Sql(PRODUCT,A.) = %Sql(PRODUCT,C.)) OR %Sql(PRODUCT,C.) = ' ') AND (( %Sql(FUND_CODE,A.) <> ' ' AND %Sql(FUND_CODE,A.) = %Sql(FUND_CODE,C.)) OR %Sql(FUND_CODE,C.) = ' ') AND (( %Sql(CLASS_FLD,A.) <> ' ' AND %Sql(CLASS_FLD,A.) = %Sql(CLASS_FLD,C.)) OR %Sql(CLASS_FLD,C.) = ' ') AND (( %Sql(PROGRAM_CODE,A.) <> ' ' AND %Sql(PROGRAM_CODE,A.) = %Sql(PROGRAM_CODE,C.)) OR %Sql(PROGRAM_CODE,C.) = ' ') AND (( %Sql(BUDGET_REF,A.) <> ' ' AND %Sql(BUDGET_REF,A.) = %Sql(BUDGET_REF,C.)) OR %Sql(BUDGET_REF,C.) = ' ') AND (( %Sql(AFFILIATE,A.) <> ' ' AND %Sql(AFFILIATE,A.) = %Sql(AFFILIATE,C.)) OR %Sql(AFFILIATE,A.) = ' ') AND (( %Sql(AFFILIATE_INTRA1,A.) <> ' ' AND %Sql(AFFILIATE_INTRA1,A.) = %Sql(AFFILIATE_INTRA1,C.)) OR %Sql(AFFILIATE_INTRA1,C.) = ' ') AND (( %Sql(AFFILIATE_INTRA2,A.) <> ' ' AND %Sql(AFFILIATE_INTRA2,A.) = %Sql(AFFILIATE_INTRA2,C.)) OR %Sql(AFFILIATE_INTRA2,C.) = ' ') AND (( A.BUSINESS_UNIT_PC <> ' ' AND A.BUSINESS_UNIT_PC = C.BUSINESS_UNIT_PC) OR C.BUSINESS_UNIT_PC = ' ') AND (( A.PROJECT_ID <> ' ' AND A.PROJECT_ID = C.PROJECT_ID) OR C.PROJECT_ID = ' ') AND (( A.ACTIVITY_ID <> ' ' AND A.ACTIVITY_ID = C.ACTIVITY_ID) OR C.ACTIVITY_ID = ' ') AND (( A.RESOURCE_TYPE <> ' ' AND A.RESOURCE_TYPE = C.RESOURCE_TYPE) OR C.RESOURCE_TYPE = ' ') AND (( A.BUDGET_PERIOD <> ' ' AND A.BUDGET_PERIOD = C.BUDGET_PERIOD) OR C.BUDGET_PERIOD = ' ') AND (( A.SCENARIO <> ' ' AND A.SCENARIO = C.SCENARIO) OR C.SCENARIO = ' ') AND (( A.BOOK_CODE <> ' ' AND A.BOOK_CODE = C.BOOK_CODE) OR C.BOOK_CODE = ' ') AND (( A.GL_ADJUST_TYPE <> ' ' AND A.GL_ADJUST_TYPE = C.GL_ADJUST_TYPE) OR C.GL_ADJUST_TYPE = ' ') AND (( A.ANALYSIS_TYPE <> ' ' AND A.ANALYSIS_TYPE = C.ANALYSIS_TYPE) OR C.ANALYSIS_TYPE = ' ') AND (( A.RESOURCE_SUB_CAT <> ' ' AND A.RESOURCE_SUB_CAT = C.RESOURCE_SUB_CAT) OR C.RESOURCE_SUB_CAT = ' ') AND (( A.RESOURCE_CATEGORY <> ' ' AND A.RESOURCE_CATEGORY = C.RESOURCE_CATEGORY) OR C.RESOURCE_CATEGORY = ' ') AND (( A.CURRENCY_CD <> ' ' AND A.CURRENCY_CD = C.CURRENCY_CD) OR C.CURRENCY_CD = ' ') AND (( A.STATISTICS_CODE <> ' ' AND A.STATISTICS_CODE = C.STATISTICS_CODE) OR C.STATISTICS_CODE = ' ') AND (( A.PROCESS_STEP <> ' ' AND A.PROCESS_STEP = C.PROCESS_STEP) OR C.PROCESS_STEP = ' ') ) UNION ALL SELECT D.PROCESS_INSTANCE , 0 , D.RUN_CNTL_ID , D.OPRID , D.SETID , D.PROCESS_STEP , D.PROCESS_BEGIN , D.PROCESS_END , D.DATE_CHAR , D.TIMESTAMPFIELDNAME , '*****' , 0 , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , ' ' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , ' ' , ' ' , ' ' ,%Sql(FS_CF_SPACES) , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , D.SCE_ID , D.RTBL_SCENARIO FROM PS_RTBL_ALLOC_CF D

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 PROCESS_INSTANCE2 Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 PROCESS_STEP Character(10) VARCHAR2(10) NOT NULL Process Step
7 PROCESS_BEGIN Number(10,0) DECIMAL(10) NOT NULL Begin Process Instance
8 PROCESS_END Number(10,0) DECIMAL(10) NOT NULL End Process Instance
9 DATE_CHAR Character(26) VARCHAR2(26) NOT NULL Generic space field
10 TIMESTAMPFIELDNAME Character(18) VARCHAR2(18) NOT NULL Row Level TimeStamp Field Name
11 PROCESSING_BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
12 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
14 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
15 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.
16 ALLOC_POOL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Allocations Pool Amount
17 ALLOC_POOL_PBA Signed Number(28,3) DECIMAL(26,3) NOT NULL Allocations Pool PBA Amount
18 ALLOC_POOL_PTR Signed Number(28,3) DECIMAL(26,3) NOT NULL Log posted tran amount
19 ALLOC_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Alloc Basis Amt
20 ALLOC_BASIS_TOT Signed Number(28,3) DECIMAL(26,3) NOT NULL Alloc Basis Total
21 ALLOC_TARG_OFF_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Alloc Target/Offset Amount
22 ALLOC_TARG_OFF_PBA Signed Number(28,3) DECIMAL(26,3) NOT NULL Alloc Target/Offset PBA Amt
23 ALLOC_TARG_OFF_PTR Signed Number(28,3) DECIMAL(26,3) NOT NULL Target/Offset posted transaction amount
24 LOGICAL_RECORD Character(1) VARCHAR2(1) NOT NULL Allocations Logical Record
O=Offset
T=Target
25 SELECT_CHKBOX3 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes
26 SELECT_CHKBOX4 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes
27 SELECT_CHKBOX5 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes
28 SELECT_CHKBOX6 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes
29 SELECT_CHKBOX2 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes
30 SELECT_CHKBOX1 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes
31 SELECT_CHKBOX7 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
32 SELECT_CHKBOX8 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
33 SELECT_CHKBOX9 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
34 SELECT_CHKBOX10 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
35 SELECT_CHKBOX11 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
36 SELECT_CHKBOX12 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
37 SELECT_CHKBOX13 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
38 SELECT_CHKBOX14 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
39 SELECT_CHKBOX15 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
40 SELECT_CHKBOX16 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
41 SELECT_CHKBOX17 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
42 SELECT_CHKBOX18 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
43 SELECT_CHKBOX19 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
44 SELECT_CHKBOX20 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
45 SELECT_CHKBOX21 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
46 SELECT_CHKBOX22 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
47 SELECT_CHKBOX23 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
48 SELECT_CHKBOX24 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
49 SELECT_CHKBOX25 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
50 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
51 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
52 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
53 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPER_UNIT_TBL

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

Prompt Table: PRODUCT_TBL

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

Prompt Table: FUND_TBL

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

Prompt Table: CLASS_CF_TBL

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

Prompt Table: PROGRAM_TBL

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

Prompt Table: BUD_REF_TBL

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CHARTFIELD1_TBL

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

Prompt Table: CHARTFIELD2_TBL

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

Prompt Table: CHARTFIELD3_TBL

65 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
66 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
67 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
68 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
69 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period
70 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
71 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code
72 GL_ADJUST_TYPE Character(4) VARCHAR2(4) NOT NULL Adjustment Type
73 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
74 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
75 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
76 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
77 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
78 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
79 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code
80 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID
81 RTBL_SCENARIO Character(18) VARCHAR2(18) NOT NULL Scenario Name