PSCOLORDEFN

(SQL Table)
Index Back

Color Definition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 COLORNAME Character(30) VARCHAR2(30) NOT NULL Color Name
3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
4 WINCOLORREF Signed Number(6,0) DECIMAL(5) NOT NULL Windows Color Reference
5 COLORREF Number(10,0) DECIMAL(10) NOT NULL Color Reference
6 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.
7 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.