HRCD_USER_RECNT

(SQL Table)
Index Back

Company Directory-Recently Vwd

Recently Viewed

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 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.
3 EMPLID_VIEWED Character(11) VARCHAR2(11) NOT NULL Employee ID Viewed

Prompt Table: PERSON

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 HRCD_ORGVIEW_TYPE Character(4) VARCHAR2(4) NOT NULL This field stores the Org View Type.
CDFL=Company Directory Fluid
CDOV=Company Directory
MGSS=Direct-Line Reports
MTRX=Matrix Reports