PSPTCS_MENU_TBL(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
2 | PORTAL_OBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
3 | PTCS_MENUID | 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 |