Created by Corina C Larsen, last modified by Miki Yanagi on Apr 11, 2019

Click here to see the UM_HR_ACCTG_LN - Payroll Accounting Line table and fields. 

UM_HR_ACCTG_VW has the same fields.

Created Field Name

Description

Query Usage Example

TypeAggregate?Code

EMPLID

Extracts the EMPLID from the JRNL_LN_REF  field so the table can be displayed and joined to Employee data to return additional demographics(ex-UM_FGLEMPLOY_VW


UMS_DTS_UM_HR_ACCTG_LN_TEST

Character, 7No
Extract EMPL_RCD 
/*+ Extract EMPLID */
SUBSTR(A.JRNL_LN_REF,length(A.JRNL_LN_REF)-8,7)
EMPLIDSimpler calculation for EMPLID


Extract EMPL_RCD 
/*+JEID*/
SUBSTR(A.JRNL_LN_REF,1,7)
EMPL_RCDExtracts the EMPL_RCD from the JRNL_LN_REF  field so the table can be displayed and joined to Employee data to return additional demographics(ex-UM_FGLEMPLOY_VW

UMS_DTS_UM_HR_ACCTG_LN_TEST

Character, 2No
Extract EMPL_RCD 
/*+ Extract EMPL_RCD */
SUBSTR(A.JRNL_LN_REF,length(A.JRNL_LN_REF)-8,1)