PERS_CNTRCT_TYP (SQL Table)	Index Back
Contract Type CONTRACT_TYPE identifies types of Contracts by REG_REGION. This table is used as an edit table when recording employee contracts. This data is part of theManage Labor Relations module.

PERS_CNTRCT_TYP

(SQL Table)

Contract Type

CONTRACT_TYPE identifies types of Contracts by REG_REGION. This table is used as an edit table when recording employee contracts. This data is part of theManage Labor Relations module.

Related Language Record: PERS_CNTTYP_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_HR.REG_REGION
Prompt Table: SET_VLD_HR_09

2 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

7 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

9 CONTRACT_RULE_ESP Character(20) VARCHAR2(20) NOT NULL Contract Rule

10 CONTR_MIN_DRTN Number(2,0) SMALLINT NOT NULL Minimum Duration

11 DURATION_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Duration Unit
Default Value: M
Prompt Table: DT_COST_UNIT_VW

12 CONTR_MAX_DRTN Number(2,0) SMALLINT NOT NULL Maximun Duration

13 DURATION2_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Duration Unit
Default Value: M
Prompt Table: DT_COST_UNIT_VW

14 ALLOWED_CNTR_EXT Character(1) VARCHAR2(1) NOT NULL Allowed Extensions
Y/N Table Edit
Default Value: N

15 SSN_EMPL_TYPE Character(3) VARCHAR2(3) NOT NULL Social Security Number Type
1=Regular
2=Apprenticeship
3=Training
Default Value: 1

16 REDUCTION_ID_ESP Character(3) VARCHAR2(3) NOT NULL Reduction ID
Prompt Table: %EDITTABLE

17 CNT_TYPE_APPL_ITA Character(1) VARCHAR2(1) NOT NULL Contract Type Applicability
A=All
E=Employee
N=Non-Employee
Default Value: A

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.REG_REGION Prompt Table: SET_VLD_HR_09
2	CONTRACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Contract Type
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
8	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
9	CONTRACT_RULE_ESP	Character(20)	VARCHAR2(20) NOT NULL	Contract Rule
10	CONTR_MIN_DRTN	Number(2,0)	SMALLINT NOT NULL	Minimum Duration
11	DURATION_UNIT_CD	Character(10)	VARCHAR2(10) NOT NULL	Duration Unit Default Value: M Prompt Table: DT_COST_UNIT_VW
12	CONTR_MAX_DRTN	Number(2,0)	SMALLINT NOT NULL	Maximun Duration
13	DURATION2_UNIT_CD	Character(10)	VARCHAR2(10) NOT NULL	Duration Unit Default Value: M Prompt Table: DT_COST_UNIT_VW
14	ALLOWED_CNTR_EXT	Character(1)	VARCHAR2(1) NOT NULL	Allowed Extensions Y/N Table Edit Default Value: N
15	SSN_EMPL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Social Security Number Type 1=Regular 2=Apprenticeship 3=Training Default Value: 1
16	REDUCTION_ID_ESP	Character(3)	VARCHAR2(3) NOT NULL	Reduction ID Prompt Table: %EDITTABLE
17	CNT_TYPE_APPL_ITA	Character(1)	VARCHAR2(1) NOT NULL	Contract Type Applicability A=All E=Employee N=Non-Employee Default Value: A