LM_STG_LOAD_AET(SQL Table) |
Index Back |
|---|---|
Staging Table State RecordStaging Table 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 | 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 | LM_EIP_AE_PROG | Character(12) | VARCHAR2(12) NOT NULL | EIPs Application Engine Prog |
| 5 | LM_EIP_PROC_NAME | Character(3) | VARCHAR2(3) NOT NULL |
Defines the EIP Application Engine Process Name
0=Please Select a Process... CAT=Catalog Data CMP=HR Company Data CST=Cost Acknowledgment DEP=Organization Data DIF=DIF Balance EPH=User Photo HRS=Training Hour Acknowledgment INS=Instance Qualifier Data PIT=Person of Interest Types PRF=Profile Data PRP=Persons of Interest Data PRS=Person Data PTY=Profile Type WRK=Workforce Data |
| 6 | LM_PRE_LOAD_STEPS | Character(1) | VARCHAR2(1) NOT NULL |
Validate Staging Tables
Y/N Table Edit |
| 7 | LM_LOAD_STEPS | Character(1) | VARCHAR2(1) NOT NULL |
Load Staging Table
Y/N Table Edit |
| 8 | LM_DELETE_STEPS | Character(1) | VARCHAR2(1) NOT NULL |
Delete Staging Tables
Y/N Table Edit |
| 9 | LM_ACTION_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Action Description |
| 10 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 11 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 12 | LM_CNT_VALID_FLG | Character(1) | VARCHAR2(1) NOT NULL | Content validation Flag |
| 13 | LM_HR_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | EMPLID from the HR System |
| 14 | LM_HR_EMPLID_FROM | Character(11) | VARCHAR2(11) NOT NULL | EMPLID from the HR System |
| 15 | LM_HR_EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL | EMPLID in the Person/Workforce data loads |
| 16 | LM_HR_SETID_FROM | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 17 | LM_HR_SETID_TO | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 18 | LM_SETID_WHERE | Character(254) | VARCHAR2(254) NOT NULL | SETID WHERE |
| 19 | LM_SETID_SQL_WHERE | Character(254) | VARCHAR2(254) NOT NULL | SETID WHERE |
| 20 | LM_SETID_PC_WHERE | Character(254) | VARCHAR2(254) NOT NULL | SETID WHERE |
| 21 | LM_ERR_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Error |
| 22 | LM_EIP_CTRL_ID | Number(10,0) | DECIMAL(10) NOT NULL | EIP Control Id |
| 23 | LM_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Field to keep track of the count of id fields |
| 24 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |