GB_GROUP_IDVERSIONGBQDMHR_LBR_GBVER_VW(SQL View) |
Index Back |
|---|---|
Group Build Version ViewThis view provides the latest version number for Group Build results for each Group_Id and Results Table. |
| SELECT A.GB_GROUP_ID , A.VERSIONGBQDM , A.GB_RECNAME_RESULT , A.CREATION_DT , A.CREATION_TIME FROM PS_GB_VERSION_MGMT A WHERE A.VERSIONGBQDM = ( SELECT MAX(A1.VERSIONGBQDM) FROM PS_GB_VERSION_MGMT A1 WHERE A1.GB_GROUP_ID = A.GB_GROUP_ID AND A1.GB_RECNAME_RESULT = A.GB_RECNAME_RESULT ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 2 | VERSIONGBQDM |
Number(10,0) | DECIMAL(10) NOT NULL | Version Number |
| 3 | GB_RECNAME_RESULT | Character(18) | VARCHAR2(18) NOT NULL | Result Table |
| 4 | CREATION_DT | Date(10) | DATE | Creation Date |
| 5 | CREATION_TIME | Time(15) | TIMESTAMP | CreationTime |