LM_EXT_EIP_AET(SQL Table) |
Index Back |
|---|---|
Objectives-EXT EIPObjectives-EXT EIP 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_ERR_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Error |
| 5 | LM_SETID_WHERE | Character(254) | VARCHAR2(254) NOT NULL | SETID WHERE |
| 6 | LM_SETID_SQL_WHERE | Character(254) | VARCHAR2(254) NOT NULL | SETID WHERE |
| 7 | LM_SETID_PC_WHERE | Character(254) | VARCHAR2(254) NOT NULL | SETID WHERE |
| 8 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 9 | LM_OBJV_ID | Number(10,0) | DECIMAL(10) NOT NULL | Objective ID. System Generated ID Number associated with each Objective. |
| 10 | LM_REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | REview points for Rating models from HRMS |
| 11 | LM_EXT_SRC_CD | Character(10) | VARCHAR2(10) NOT NULL | External Source Code |
| 12 | LM_EIPAUDIT_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Audit action for External EIP
A=Add D=Delete Action U=Update |