ADDL_PAY_ERNCD (SQL Table)	Index Back
Add'l Pay Earning Code ADDL_PAY_ERNCD is the earnings code control record for ADDL_PAY_DATA. Warning! The schema for this record, which is shared by Payroll and Benefits, shows that it is keyed by EMPL_RCD. For those rows managed by Benefits Administration (ADDL_REASON="BAS"), this is not logically or functionally accurate. Within the context of benefit enrollment (and by extension, benefits-generated additional pay), EMPL_RCD must be interpreted as an alias for BENEFIT_RCD_NBR. All benefit enrollment-related records are logically keyed by BENEFIT_RCD_NBR, so for ADDL_PAY rows managed by Benefits the EMPL_RCD actually contains the value of the appropriate BENEFIT_RCD_NBR. It is CRITICAL that all joins, comparisons, and updates to such rows be against BENEFIT_RCD_NBR.

ADDL_PAY_ERNCD

(SQL Table)

Add'l Pay Earning Code

ADDL_PAY_ERNCD is the earnings code control record for ADDL_PAY_DATA. Warning! The schema for this record, which is shared by Payroll and Benefits, shows that it is keyed by EMPL_RCD. For those rows managed by Benefits Administration (ADDL_REASON="BAS"), this is not logically or functionally accurate. Within the context of benefit enrollment (and by extension, benefits-generated additional pay), EMPL_RCD must be interpreted as an alias for BENEFIT_RCD_NBR. All benefit enrollment-related records are logically keyed by BENEFIT_RCD_NBR, so for ADDL_PAY rows managed by Benefits the EMPL_RCD actually contains the value of the appropriate BENEFIT_RCD_NBR. It is CRITICAL that all joins, comparisons, and updates to such rows be against BENEFIT_RCD_NBR.

Parent record: PER_ORG_ASGN_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: PER_ORG_ASGN_VW

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

4 RECORD_SOURCE Character(1) VARCHAR2(1) NOT NULL Record Source
B=Batch
O=On-line
Default Value: O

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: PER_ORG_ASGN_VW
3	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code Prompt Table: PY_EARNINGS_VW
4	RECORD_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Record Source B=Batch O=On-line Default Value: O