HRS_TG_NAMEHRS_TG_VER10=Active
20=Deprecated
30=In Progress
40=Retired
HRS_TG_RVRSE_VW(SQL View) |
Index Back |
|---|
| SELECT HRS_TG_NAME , HRS_TG_VER , HRS_TG_ID , HRS_TG_STATUS FROM PS_HRS_TGROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_TG_NAME |
Character(15) | VARCHAR2(15) NOT NULL | Transaction Group Name |
| 2 | HRS_TG_VER |
Number(4,0) | SMALLINT NOT NULL | Transaction Group Version |
| 3 | HRS_TG_ID | Number(15,0) | DECIMAL(15) NOT NULL | Transaction Group ID |
| 4 | HRS_TG_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Group Status (Active/Deprecated/In Progress/Retired)
10=Active 20=Deprecated 30=In Progress 40=Retired |