HR_PAY_STG (SQL Table)	Index Back
Payroll Staging Table Staging Table for Payroll Data. Used for Wage Progression

HR_PAY_STG

(SQL Table)

Payroll Staging Table

Staging Table for Payroll Data. Used for Wage Progression

Parent Record Of HR_PAY_ERNS_AET HR_PAY_ERN_TMP HR_PAY_STG2_TAO HR_PAY_STG_ERNS HR_P_ERN_TAO4 HR_P_STG_TAO2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 PAY_END_DT Date(10) DATE Pay Period End Date
Default Value: %date

4 PAY_SEQ_NO Number(3,0) SMALLINT NOT NULL Payroll Sequence Number

5 ERNCD_SPCL Character(3) VARCHAR2(3) NOT NULL Special Accumulator Code

6 SPCL_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Special Hours

7 SOURCE_OF_ROW Character(10) VARCHAR2(10) NOT NULL Source of Row

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	PAY_END_DT	Date(10)	DATE	Pay Period End Date Default Value: %date
4	PAY_SEQ_NO	Number(3,0)	SMALLINT NOT NULL	Payroll Sequence Number
5	ERNCD_SPCL	Character(3)	VARCHAR2(3) NOT NULL	Special Accumulator Code
6	SPCL_HRS	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Special Hours
7	SOURCE_OF_ROW	Character(10)	VARCHAR2(10) NOT NULL	Source of Row