PSPTCS_MENU_TBL(SQL Table) | 
Index Back | 
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name | |
| 3 | Character(30) | VARCHAR2(30) NOT NULL | Menu | |
| 4 | PTCS_MENUTYPE | Character(4) | VARCHAR2(4) NOT NULL | 
Menu Display Type
 FLDM=Field Menu MMNU=Drop-Down Menu PGBM=Pivot grid Bulk Menu RCF=Related Content Frame RCMU=Related Content Menu  | 
| 5 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). | 
| 6 | PTCS_PNLFLDNAME | Character(254) | VARCHAR2(254) NOT NULL | Page Field Name | 
| 7 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | 
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
 Default Value: 1  | 
| 8 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. | 
| 9 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. | 
| 10 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |