PC_SEL_VALU_WRK

(SQL Table)
Index Back

Custom Field Values

PC-AM: Selection criteria for custom fields

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
4 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
6 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Field Value