LM_STG_LOAD_AET

(SQL Table)
Index Back

Staging Table State Record

Staging 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