LM_PRSCOMP_AET

(SQL Table)
Index Back

Person competency State Recor

Person competency Fullsync State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 LM_HR_EMPLID_FROM Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
3 LM_HR_EMPLID_TO Character(11) VARCHAR2(11) NOT NULL EMPLID in the Person/Workforce data loads
4 LM_EVAL_ID Character(2) VARCHAR2(2) NOT NULL LM evaluation ID
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 LM_EXT_CD Character(30) VARCHAR2(30) NOT NULL External objective code
7 LM_REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL REview points for Rating models from HRMS
8 LM_OBJV_DESC Character(100) VARCHAR2(100) NOT NULL Objective description.
9 LM_ERR_DESCR Character(254) VARCHAR2(254) NOT NULL Error
10 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
11 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
12 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
13 LM_TO_POINTS Number(3,0) SMALLINT NOT NULL Points for Rating Models from HRMS
14 LM_FROM_POINTS Number(3,0) SMALLINT NOT NULL Points for Rating models from HRMS
15 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
16 LM_PROCESS Character(1) VARCHAR2(1) NOT NULL Process
17 LM_PRCS_PRE_PRSLD Character(1) VARCHAR2(1) NOT NULL Process Person Pre-Load Steps
18 LM_PRCS_PRSLD Character(1) VARCHAR2(1) NOT NULL Process Person Load