FMLA_PAY_AUDIT (SQL Table)	Index Back
FMLA Pay Audit Earn Code List The FMLA PAY AUDIT table is used to assist the user in entering the list of Earnings Codes to be audited by the FMLA Payroll Audit report. The table is populated within the Run Control for this report, and contains each ErnCd which may reflect paid time off used during an FMLA protected leave.

FMLA_PAY_AUDIT

(SQL Table)

FMLA Pay Audit Earn Code List

The FMLA PAY AUDIT table is used to assist the user in entering the list of Earnings Codes to be audited by the FMLA Payroll Audit report. The table is populated within the Run Control for this report, and contains each ErnCd which may reflect paid time off used during an FMLA protected leave.

Parent record: PRCSRUNCNTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: RUN_CNTL_BEN.OPRID

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
Default Value: RUN_CNTL_BEN.RUN_CNTL_ID

3 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
Prompt Table: EARNINGS_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: RUN_CNTL_BEN.OPRID
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID Default Value: RUN_CNTL_BEN.RUN_CNTL_ID
3	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code Prompt Table: EARNINGS_TBL