SCE_IDSETIDPROCESS_GROUPRTBL_ELEMENTVERSION_NUMCURR_STEPFIN=Final
FST=First
INT=Intermediate
M=Translate Within Ledger
R=Currency Revaluation
T=Currency Translation
LEVEL_NUMRTBL_MULTI_VW(SQL View) |
Index Back |
|---|
| SELECT SCE_ID , SETID , process_group , version_grp , RTBL_ELEMENT , VERSION_NUM , CURR_STEP , VERSION_NBR , STEP_TYPE , TRANS_RULE , VERSION_NUMBER , LEVEL_NUM , LEVEL1 , LEVEL2 , LEVEL3 , LEVEL4 , LEVEL5 , LEVEL6 , LEVEL7 , LEVEL8 , LEVEL9 FROM ( SELECT B.SCE_ID , A.SETID , a.process_group , a.version_grp , A.CURR_STEP AS RTBL_ELEMENT , A.VERSION_NUM , A.CURR_STEP , A.VERSION_NUM AS VERSION_NBR , STP.STEP_TYPE , ' ' AS TRANS_RULE , 0 AS VERSION_NUMBER , 1 AS LEVEL_NUM , ROW_NUMBER_5 AS LEVEL1 , 0 AS LEVEL2 , 0 AS LEVEL3 , 0 AS LEVEL4 , 0 AS LEVEL5 , 0 AS LEVEL6 , 0 AS LEVEL7 , 0 AS LEVEL8 , 0 AS LEVEL9 FROM PS_CURR_GRSTP_TBL A , ps_rtbl_mulstp_vw b , ps_curr_step_tbl STP WHERE a.setid = b.setid AND a.curr_step = b.curr_step AND a.version_num = b.version_num AND ((stp.effdt = b.effdt AND stp.version_num = 0) OR stp.version_num > 0) AND stp.eff_status = 'A' AND stp.setid = a.setid AND stp.curr_step = a.curr_step AND stp.version_num = a.version_num UNION SELECT C.SCE_ID , A.SETID , a.process_group , a.version_grp , B.TRANS_RULE AS RTBL_ELEMENT , B.VERSION_RULE , A.CURR_STEP , a.version_num AS VERSION_NBR , ' ' AS STEP_TYPE , B.TRANS_RULE , B.VERSION_RULE AS VERSION_NUMBER , 2 AS LEVEL_NUM , c.row_number_5 AS LEVEL1 , ROW_NUMBER() OVER ( partition BY c.row_number_5 ORDER BY c.row_number_5) AS LEVEL2 , 0 AS LEVEL3 , 0 AS LEVEL4 , 0 AS LEVEL5 , 0 AS LEVEL6 , 0 AS LEVEL7 , 0 AS LEVEL8 , 0 AS LEVEL9 FROM PS_CURR_GRSTP_TBL A , PS_CURR_STPRL_TBL B , ps_rtbl_mulstp_vw C WHERE A.SETID = B.SETID AND A.CURR_STEP = B.CURR_STEP AND a.version_num = b.version_num AND a.setid = c.setid AND a.curr_step = c.curr_step AND a.version_num = c.version_num AND (B.VERSION_NUM =0 AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_CURR_STPRL_TBL B_ED WHERE B.SETID = B_ED.SETID AND B.CURR_STEP = B_ED.CURR_STEP AND B.VERSION_NUM = B_ED.VERSION_NUM AND B_ED.EFFDT <= C.EFFDT ) OR B.VERSION_NUM > 0)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | ID |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | PROCESS_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Process Group |
| 4 | VERSION_GRP | Number(3,0) | SMALLINT NOT NULL | Group Version |
| 5 | RTBL_ELEMENT |
Character(30) | VARCHAR2(30) NOT NULL | Element name to identify (in peoplesoft) an element along with its label. |
| 6 | VERSION_NUM |
Number(3,0) | SMALLINT NOT NULL | Version Number |
| 7 | CURR_STEP |
Character(10) | VARCHAR2(10) NOT NULL | Process Step |
| 8 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 9 | STEP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Currency Processing Step Type
FIN=Final FST=First INT=Intermediate M=Translate Within Ledger R=Currency Revaluation T=Currency Translation |
| 10 | TRANS_RULE | Character(10) | VARCHAR2(10) NOT NULL | Translation Rule |
| 11 | VERSION_NUMBER | Number(5,0) | INTEGER NOT NULL | Represents the Tools version number of a given position tree object. |
| 12 | LEVEL_NUM |
Number(3,0) | SMALLINT NOT NULL | Level |
| 13 | LEVEL1 | Number(5,0) | INTEGER NOT NULL | Level 1 |
| 14 | LEVEL2 | Number(5,0) | INTEGER NOT NULL | Level 2 |
| 15 | LEVEL3 | Number(5,0) | INTEGER NOT NULL | Level 3 |
| 16 | LEVEL4 | Number(5,0) | INTEGER NOT NULL | Level 4 |
| 17 | LEVEL5 | Number(5,0) | INTEGER NOT NULL | Level 5 |
| 18 | LEVEL6 | Number(5,0) | INTEGER NOT NULL | Level 6 |
| 19 | LEVEL7 | Number(5,0) | INTEGER NOT NULL | Level 7 |
| 20 | LEVEL8 | Number(5,0) | INTEGER NOT NULL | Level 8 |
| 21 | LEVEL9 | Number(5,0) | INTEGER NOT NULL | Level 9 |