HRS_TG_ID10=Active
20=Deprecated
30=In Progress
40=Retired
Default Value: 30
Prompt Table: HRS_TGACEXT_PT
Prompt Table: HRS_TRNSFR_M_PT
Prompt Table: HRS_TRNSFR_B_PT
Prompt Table: HRS_TRNSFR_I_PT
Prompt Table: HRS_TRNSFR_P_PT
HRS_TGROUP(SQL Table) |
Index Back |
|---|
| # | 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_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Group Status (Active/Deprecated/In Progress/Retired)
10=Active 20=Deprecated 30=In Progress 40=Retired Default Value: 30 |
| 4 | HRS_TG_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Transaction Group Description |
| 5 | HRS_TG_VER | Number(4,0) | SMALLINT NOT NULL | Transaction Group Version |
| 6 | HRS_APPCLASS_ID | Character(25) | VARCHAR2(25) NOT NULL |
Application Class
Prompt Table: HRS_TGACEXT_PT |
| 7 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table: HRS_TRNSFR_M_PT |
| 8 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table: HRS_TRNSFR_B_PT |
| 9 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL |
Item Name
Prompt Table: HRS_TRNSFR_I_PT |
| 10 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table: HRS_TRNSFR_P_PT |
| 11 | HRS_TG_EX_XML | Long Character | CLOB | Transaction Group Extension XML |