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 |