HS_EMPLOYMENT (SQL Table)	Index Back
EE General Employment Data EMPLOYMENT is one of the core records in the database. Use it to record an employee's employment-related data that doesn't tend to change, such as hire date, termination date, and company service date.

HS_EMPLOYMENT

(SQL Table)

EE General Employment Data

EMPLOYMENT is one of the core records in the database. Use it to record an employee's employment-related data that doesn't tend to change, such as hire date, termination date, and company service date.

Parent record: PER_ORG_ASGN_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: PERSON.EMPLID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee

4 EMPL_SECURE_SW_CAN Character(1) VARCHAR2(1) NOT NULL Employment Secure
Y/N Table Edit
Default Value: Y

5 REL_PARTNER_SW_CAN Character(1) VARCHAR2(1) NOT NULL Partner
Y/N Table Edit
Default Value: N

6 REL_PRNCPL_SW_CAN Character(1) VARCHAR2(1) NOT NULL Principal
Y/N Table Edit
Default Value: N

7 REL_RLTV_SW_CAN Character(1) VARCHAR2(1) NOT NULL Relative
Y/N Table Edit
Default Value: N

8 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
Prompt Table: REG_HANDS_VW

9 EMPTYP_FTW_SW_CAN Character(1) VARCHAR2(1) NOT NULL Full Time
Y/N Table Edit
Default Value: N

10 EMPTYP_PER_SW_CAN Character(1) VARCHAR2(1) NOT NULL Permanent
Y/N Table Edit
Default Value: N

11 EMPTYP_SNL_SW_CAN Character(1) VARCHAR2(1) NOT NULL Seasonal
Y/N Table Edit
Default Value: N

12 EMPTYP_CSL_SW_CAN Character(1) VARCHAR2(1) NOT NULL Casual
Y/N Table Edit
Default Value: N

13 EMPTYP_VLN_SW_CAN Character(1) VARCHAR2(1) NOT NULL Volunteer
Y/N Table Edit
Default Value: N

14 EMPTYP_STU_SW_CAN Character(1) VARCHAR2(1) NOT NULL Student
Y/N Table Edit
Default Value: N

15 EMPTYP_SUB_SW_CAN Character(1) VARCHAR2(1) NOT NULL Subcontractor
Y/N Table Edit
Default Value: N

16 OCCUPATION_CD_CAN Character(7) VARCHAR2(7) NOT NULL Occupation Code
Prompt Table: OCCUPAT_CAN_TBL

17 WRKR_CAT_CD Character(3) VARCHAR2(3) NOT NULL Worker Category
CAS=Casual

18 WCB_OCC_CAT Character(3) VARCHAR2(3) NOT NULL Occupational Category
NA=Not Applicable

19 JOB_AVL_MONTHS_CAN Number(3,0) SMALLINT NOT NULL Job Available Months

20 IND_START_DT_CAN Date(10) DATE Industry Start Date

21 SNL_END_DT_CAN Date(10) DATE Seasonal End Date

22 EXT_SCHEME_CD_UK Character(3) VARCHAR2(3) NOT NULL EXT_SCHEME_CD_UK
Prompt Table: EXT_SCHM_TBL_UK

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PERSON.EMPLID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationship to Employee
4	EMPL_SECURE_SW_CAN	Character(1)	VARCHAR2(1) NOT NULL	Employment Secure Y/N Table Edit Default Value: Y
5	REL_PARTNER_SW_CAN	Character(1)	VARCHAR2(1) NOT NULL	Partner Y/N Table Edit Default Value: N
6	REL_PRNCPL_SW_CAN	Character(1)	VARCHAR2(1) NOT NULL	Principal Y/N Table Edit Default Value: N
7	REL_RLTV_SW_CAN	Character(1)	VARCHAR2(1) NOT NULL	Relative Y/N Table Edit Default Value: N
8	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Prompt Table: REG_HANDS_VW
9	EMPTYP_FTW_SW_CAN	Character(1)	VARCHAR2(1) NOT NULL	Full Time Y/N Table Edit Default Value: N
10	EMPTYP_PER_SW_CAN	Character(1)	VARCHAR2(1) NOT NULL	Permanent Y/N Table Edit Default Value: N
11	EMPTYP_SNL_SW_CAN	Character(1)	VARCHAR2(1) NOT NULL	Seasonal Y/N Table Edit Default Value: N
12	EMPTYP_CSL_SW_CAN	Character(1)	VARCHAR2(1) NOT NULL	Casual Y/N Table Edit Default Value: N
13	EMPTYP_VLN_SW_CAN	Character(1)	VARCHAR2(1) NOT NULL	Volunteer Y/N Table Edit Default Value: N
14	EMPTYP_STU_SW_CAN	Character(1)	VARCHAR2(1) NOT NULL	Student Y/N Table Edit Default Value: N
15	EMPTYP_SUB_SW_CAN	Character(1)	VARCHAR2(1) NOT NULL	Subcontractor Y/N Table Edit Default Value: N
16	OCCUPATION_CD_CAN	Character(7)	VARCHAR2(7) NOT NULL	Occupation Code Prompt Table: OCCUPAT_CAN_TBL
17	WRKR_CAT_CD	Character(3)	VARCHAR2(3) NOT NULL	Worker Category CAS=Casual
18	WCB_OCC_CAT	Character(3)	VARCHAR2(3) NOT NULL	Occupational Category NA=Not Applicable
19	JOB_AVL_MONTHS_CAN	Number(3,0)	SMALLINT NOT NULL	Job Available Months
20	IND_START_DT_CAN	Date(10)	DATE	Industry Start Date
21	SNL_END_DT_CAN	Date(10)	DATE	Seasonal End Date
22	EXT_SCHEME_CD_UK	Character(3)	VARCHAR2(3) NOT NULL	EXT_SCHEME_CD_UK Prompt Table: EXT_SCHM_TBL_UK