RTBL_ELEMGRP_VW(SQL View) |
Index Back |
|---|
| SELECT SETID , PROCESS_GROUP AS RTBL_ELEMENT , VERSION_GRP AS VERSION_NUM , ' ' AS CLOSING_TYPE , DEPLOYED , 'A' AS RTBL_ELEMENT_TYPE FROM PS_ALLOC_GROUP_TBL WHERE version_grp > 0 UNION SELECT SETID , PROCESS_GROUP AS RTBL_ELEMENT , VERSION_GRP AS VERSION_NUM , ' ' AS CLOSING_TYPE , DEPLOYED , 'M' AS RTBL_ELEMENT_TYPE FROM PS_CURR_GROUP_TBL WHERE version_grp > 0 UNION SELECT SETID , CLOSE_GRP_ID AS RTBL_ELEMENT , VERSION_GRP AS VERSION_NUM , CLOSING_TYPE , DEPLOYED , 'C' AS RTBL_ELEMENT_TYPE FROM PS_CLOSE_GRP_PRC WHERE version_grp > 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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 | DEPLOYED | Character(1) | VARCHAR2(1) NOT NULL |
Identify whether an element has been deployed or not.
N=No Y=Yes |
| 6 | 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 |