FO_OI_TG_ID10=Active
20=Deprecated
30=In Progress
40=Retired
Default Value: 30
FO_TGROUP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FO_OI_TG_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Transaction Group ID |
| 2 | FO_OI_TG_NAME | Character(15) | VARCHAR2(15) NOT NULL | Transaction Group Name |
| 3 | FO_OI_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 | FO_OI_TG_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Transaction Group Description |
| 5 | FO_OI_TG_VER | Number(4,0) | SMALLINT NOT NULL | Transaction Group Version |
| 6 | FO_APPCLASS_ID | Character(25) | VARCHAR2(25) NOT NULL | Application Class |
| 7 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 8 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
| 9 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Item Name |
| 10 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 11 | FO_TG_EX_XML | Long Character(2000) | VARCHAR2(2000) | Transaction Group Extension XML |