HCR_OPRDEF_HR_I

(SQL View)
 Index Back

Operator Defaults HR Interf V

Operator Defaults HR Interface View

SELECT A.OPRCLASS , A.BUSINESS_UNIT , A.SETID , A.REG_REGION , A.COMPANY , A.COUNTRY , A.EXCHNG_TO_CURRENCY , A.EXCHNG_TO_RT_TYPE , A.MIN_STD_HRS , A.MAX_STD_HRS , A.STD_HRS_DEFAULT , A.STD_HRS_FREQUENCY , A.CAN_CMA , A.CAN_IND_SECTOR , A.PAY_SYSTEM_FLG , A.ALT_CHAR_ENABLED , A.CARRY_ID , A.INDUSTRY , A.INDUSTRY_SECTOR , A.COUNTRY_NM_FORMAT FROM PS_OPR_DEF_TBL_HR A

# 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