SETIDPROCESS_GROUPVERSION_GRPGROUP_TMP_VW(SQL View) |
Index Back |
|---|
| SELECT AGT.SETID , AGT.PROCESS_GROUP , AGT.VERSION_GRP ,ROW_NUMBER() OVER ( ORDER BY PROCESS_GROUP) AS ROW_NUMBER_5 FROM PS_ALLOC_GROUP_TBL AGT WHERE (AGT.version_grp >0 OR (AGT.version_grp = 0 AND AGT.effdt = ( SELECT MAX(AGT1.effdt) FROM PS_ALLOC_GROUP_TBL AGT1 WHERE AGT1.setid = AGT.setid AND AGT1.process_group = AGT.process_group AND agt1.version_grp = 0 AND AGT1.EFFDT <=SYSDATE)) ) AND AGT.BUDGET_COPY = 'N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PROCESS_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Process Group |
| 3 | VERSION_GRP |
Number(3,0) | SMALLINT NOT NULL | Group Version |
| 4 | ROW_NUMBER_5 | Number(5,0) | INTEGER NOT NULL | Row Number |