LM_DIF_BAL_AET

(SQL Table)
Index Back

DIF balance report

# 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 ASOFDATE Date(10) DATE As of Date
5 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number

Default Value: 0

6 LM_HR_COMPANY Character(3) VARCHAR2(3) NOT NULL HR's Company ID brought over during synchronization.
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

Default Value: 0

9 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID

Default Value: 0

10 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).
11 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).