OPR_DEF_TBL_HR (SQL Table)	Index Back
Operator Defaults Table - HR There is a AE(HROPRSEC) process written using this record to synch up HR security with operator security. Therefore, any structure changes to this record will also need modification in the AE process. Also, any modification to this record should be applied to OPR_DEF_BKP_TAO and OPR_DEF_HR_TAO records which the AE process HROPRSEC uses.

OPR_DEF_TBL_HR

(SQL Table)

Operator Defaults Table - HR

There is a AE(HROPRSEC) process written using this record to synch up HR security with operator security. Therefore, any structure changes to this record will also need modification in the AE process. Also, any modification to this record should be applied to OPR_DEF_BKP_TAO and OPR_DEF_HR_TAO records which the AE process HROPRSEC uses.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
Default Value: PSCLASSDEFN.CLASSID

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_HR

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

4 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
Prompt Table: REG_STANDARD_VW

5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

7 EXCHNG_TO_CURRENCY Character(3) VARCHAR2(3) NOT NULL To Currency
Prompt Table: CURRENCY_CD_TBL

8 EXCHNG_TO_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
Prompt Table: RT_TYPE_TBL

9 MIN_STD_HRS Number(7,2) DECIMAL(6,2) NOT NULL Minimum Standard Hours

10 MAX_STD_HRS Number(7,2) DECIMAL(6,2) NOT NULL Maximum Standard Hours

11 STD_HRS_DEFAULT Number(7,2) DECIMAL(6,2) NOT NULL Default Standard Hours
Default Value: 40

12 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
Default Value: W
Prompt Table: STDHRS_FREQ_VW

13 CAN_CMA Character(2) VARCHAR2(2) NOT NULL Canadian Census Metropol Area
Default Value: 06

14 CAN_IND_SECTOR Character(3) VARCHAR2(3) NOT NULL Canadian Industrial Sector
Default Value: 451

15 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
Default Value: NA

16 ALT_CHAR_ENABLED Character(1) VARCHAR2(1) NOT NULL Alternate Character Enabled
Y/N Table Edit
Default Value: N

17 CARRY_ID Character(1) VARCHAR2(1) NOT NULL Carry Employee ID
Y/N Table Edit
Default Value: N

18 INDUSTRY Character(4) VARCHAR2(4) NOT NULL Industry
CORE=Core
EDUC=Education
FNSV=Financial Services
GOVT=Government
HLTH=Health Care
RETL=Retail
TRAN=Transportation
UTIL=Utilities
Default Value: CORE

19 INDUSTRY_SECTOR Character(4) VARCHAR2(4) NOT NULL Industry Sector
CORE=Core
PBSC=Public Sector
USFG=US Federal Government
Default Value: CORE

20 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types
Prompt Table: NAME_FORMAT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class Default Value: PSCLASSDEFN.CLASSID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
4	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Prompt Table: REG_STANDARD_VW
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
6	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
7	EXCHNG_TO_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	To Currency Prompt Table: CURRENCY_CD_TBL
8	EXCHNG_TO_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Prompt Table: RT_TYPE_TBL
9	MIN_STD_HRS	Number(7,2)	DECIMAL(6,2) NOT NULL	Minimum Standard Hours
10	MAX_STD_HRS	Number(7,2)	DECIMAL(6,2) NOT NULL	Maximum Standard Hours
11	STD_HRS_DEFAULT	Number(7,2)	DECIMAL(6,2) NOT NULL	Default Standard Hours Default Value: 40
12	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period Default Value: W Prompt Table: STDHRS_FREQ_VW
13	CAN_CMA	Character(2)	VARCHAR2(2) NOT NULL	Canadian Census Metropol Area Default Value: 06
14	CAN_IND_SECTOR	Character(3)	VARCHAR2(3) NOT NULL	Canadian Industrial Sector Default Value: 451
15	PAY_SYSTEM_FLG	Character(2)	VARCHAR2(2) NOT NULL	Payroll System GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface Default Value: NA
16	ALT_CHAR_ENABLED	Character(1)	VARCHAR2(1) NOT NULL	Alternate Character Enabled Y/N Table Edit Default Value: N
17	CARRY_ID	Character(1)	VARCHAR2(1) NOT NULL	Carry Employee ID Y/N Table Edit Default Value: N
18	INDUSTRY	Character(4)	VARCHAR2(4) NOT NULL	Industry CORE=Core EDUC=Education FNSV=Financial Services GOVT=Government HLTH=Health Care RETL=Retail TRAN=Transportation UTIL=Utilities Default Value: CORE
19	INDUSTRY_SECTOR	Character(4)	VARCHAR2(4) NOT NULL	Industry Sector CORE=Core PBSC=Public Sector USFG=US Federal Government Default Value: CORE
20	COUNTRY_NM_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Supported Name Format Types Prompt Table: NAME_FORMAT_TBL