RTBL_GRSTP_VW(SQL View) |
Index Back |
|---|
| SELECT SCE.SCE_ID , a.setid , a.process_group , a.version_grp , a.effdt , a.sequence_nbr_6 , a.process_step , ' ' , ' ' , 'A' , a.version_num FROM PS_ALLOC_GRSTP_TBL a , PS_RTBL_SCENARIO SCE WHERE a.effdt = ( SELECT MAX(A_ED.EFFDT) FROM PS_ALLOC_GRSTP_TBL A_ED WHERE A.SETID = A_ED.SETID AND A.PROCESS_GROUP = A_ED.PROCESS_GROUP AND A.VERSION_GRP = A_ED.VERSION_GRP AND A_ED.EFFDT <= SCE.ASOFDATE2 ) |
| # | 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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 6 | SEQUENCE_NBR_6 |
Number(6,0) | INTEGER NOT NULL | Sequence |
| 7 | PROCESS_STEP |
Character(10) | VARCHAR2(10) NOT NULL |
Process Step
Prompt Table: %EDITTABLE |
| 8 | CLOSE_GRP_ID |
Character(20) | VARCHAR2(20) NOT NULL | Closing Process Group |
| 9 | CLOSING_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Closing Type
I=Interim Y=Year End |
| 10 | 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 |
| 11 | VERSION_NUM | Number(3,0) | SMALLINT NOT NULL |
Version Number
Default Value: 0 Prompt Table: ALLOC_NOCPY2_VW |