SCE_IDRTBL_ELEMENTVERSION_NUMCLOSING_TYPEI=Interim
Y=Year End
A=Allocation
C=Close Ledgers
J=Journal
M=Multi-currency
U=User Defined
RTBL_ERR_ST_C(SQL View) |
Index Back |
|---|
| SELECT A.SCE_ID ,B.RTBL_ELEMENT ,B.VERSION_NUM ,B.CLOSING_TYPE ,'' ,B.SETID ,2 ,B.RTBL_ELEMENT_TYPE FROM %Table(RTBL_SCENARIO) A , %Table(RTBL_ELEM_VW) B WHERE A.SCE_ID=B.SCE_ID AND A.ACTIVE_SCENARIO='Y' AND A.STATUS_SCENARIO NOT IN ('RP','RA','RD','RC','RY') AND B.RTBL_ELEMENT_TYPE='C' AND B.LEVEL_NUM=2 UNION SELECT A.SCE_ID ,B.RTBL_ELEMENT ,B.VERSION_NUM ,B.CLOSING_TYPE ,'' ,B.SETID ,2 ,B.RTBL_ELEMENT_TYPE FROM %Table(RTBL_SCENARIO) A , %Table(RTBL_DEPLOY_HIS) B WHERE A.SCE_ID=B.SCE_ID AND A.ACTIVE_SCENARIO='Y' AND A.STATUS_SCENARIO IN ('RP','RA','RD','RC','RY') AND B.RTBL_ELEMENT_TYPE='C' AND B.LEVEL_NUM=2 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | ID |
| 2 | RTBL_ELEMENT |
Character(30) | VARCHAR2(30) NOT NULL | Element name to identify (in peoplesoft) an element along with its label. |
| 3 | VERSION_NUM |
Number(3,0) | SMALLINT NOT NULL | Version Number |
| 4 | CLOSING_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Closing Type
I=Interim Y=Year End |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 7 | LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Level |
| 8 | RTBL_ELEMENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Element name to identify (in peoplesoft) an element along with its label.
A=Allocation C=Close Ledgers J=Journal M=Multi-currency U=User Defined |