RC_MASS_EE_UPD (SQL Table)	Index Back
Mass Update Run Control Programs using this run control are usually programs created to update a specific payroll related table as some process has changed and requires update to mass employee records. Currently used by TAX516AZ, which updates the state tax data table for employees when the tax percentages change in AZ.

RC_MASS_EE_UPD

(SQL Table)

Mass Update Run Control

Programs using this run control are usually programs created to update a specific payroll related table as some process has changed and requires update to mass employee records. Currently used by TAX516AZ, which updates the state tax data table for employees when the tax percentages change in AZ.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Broadcast
A=Audit
N=Do Not Process
O=Override
U=Update
Z=Resolve to zero

4 PAY_END_DT Date(10) DATE Pay Period End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	ACTION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Broadcast A=Audit N=Do Not Process O=Override U=Update Z=Resolve to zero
4	PAY_END_DT	Date(10)	DATE	Pay Period End Date