HRS_TG_IDHRS_TGROUP_SRCH(SQL View) |
Index Back |
|---|---|
Transaction Group SearchTransaction Group Search Record |
| SELECT HRS_TG_ID , HRS_TG_NAME , HRS_TG_DESCR , HRS_TG_VER FROM PS_HRS_TGROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_TG_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Transaction Group ID |
| 2 | HRS_TG_NAME | Character(15) | VARCHAR2(15) NOT NULL | Transaction Group Name |
| 3 | HRS_TG_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Transaction Group Description |
| 4 | HRS_TG_VER | Number(4,0) | SMALLINT NOT NULL | Transaction Group Version |