LM_STG_JP_PROPS

(SQL Table)
Index Back

Profile Prop Staging Table

Profile Properties Staging Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Job Profile Types
2 LM_JP_SECTION_ID Number(4,0) SMALLINT NOT NULL Section ID
3 LM_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Used to hold the field name.
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 LM_EIP_CTRL_ID Number(10,0) DECIMAL(10) NOT NULL EIP Control Id
6 LM_LABEL_TEXT Character(30) VARCHAR2(30) NOT NULL Label Text
7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
8 LM_EIP_PRCS_STTS Character(1) VARCHAR2(1) NOT NULL EIP Process status
0=Not Processed
1=Validated
2=Invalid Data
3=Loaded Successfully
4=Invalid EmplRcd Number
5=Warning Message
9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
10 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
11 BASE_LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

Prompt Table: BSLNGCDXLAT