PPK_GEN_PREFS

(SQL Table)
Index Back

PPM General Preferences

PPM general preferences.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PPK_SEQ_TYPE Character(1) VARCHAR2(1) NOT NULL Project Request ID Sequencing
A=Automatic Numbering
M=Manually Entered

Default Value: M

2 BC_PROJ_ID_PREFIX Character(5) VARCHAR2(5) NOT NULL This field holds the user defined project request ID prefix. This is appended to the front of the BC_PROJ_ID_SEQ field to form a unique project request ID.
3 BC_PROJ_ID_SEQ Number(10,0) DECIMAL(10) NOT NULL Holds the LAST USED project request ID sequence number. This is concatenated to the BC_PROJ_ID_PREFIX field to form a unique project request ID when that option is enabled.
4 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
5 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
6 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
7 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.