HR_HRSALCHG_AET

(SQL Table)
Index Back

State record for HRSALCHG

This record is used as the state record for the Application Program HRSALCHG: Find Employees w/Late Reviews.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 IF_FLAG Character(1) VARCHAR2(1) NOT NULL If flag
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
7 EFFDT Date(10) DATE Effective Date

Default Value: %date