PY_ROE_MAP_CD (SQL Table)	Index Back
ROE Mapping Table This table stores the information on ROE blocks of codes transformation for ROE Payroll Extract various versions.

PY_ROE_MAP_CD

(SQL Table)

ROE Mapping Table

This table stores the information on ROE blocks of codes transformation for ROE Payroll Extract various versions.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROE_BLOCK Character(4) VARCHAR2(4) NOT NULL Block number on Canadian ROE.
17C=Other Monies

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 MAINT_RESPONSBLTY Character(1) VARCHAR2(1) NOT NULL Maintenance Responsibility
C=Customer
P=PeopleSoft

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ROE_BLOCK	Character(4)	VARCHAR2(4) NOT NULL	Block number on Canadian ROE. 17C=Other Monies
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	MAINT_RESPONSBLTY	Character(1)	VARCHAR2(1) NOT NULL	Maintenance Responsibility C=Customer P=PeopleSoft