LM_STG_TERM(SQL Table) |
Index Back |
|---|---|
Temporary staging tableThis table holds terminated employees rows, The rows in this table are fed to ProcessAutoDrop method, which actually drops the learners. |
| # | 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 | Character(11) | VARCHAR2(11) NOT NULL | EMPLID from the HR System |
| 3 | LM_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record umber |
| 4 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | LM_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | ELM Effective Sequence |
| 6 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 7 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 8 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |