JOB_TRIGR1_ESP (SQL Table)	Index Back
Trigger creation work table Work table to create Job GP triggers. Special table to create triggers under special situations, i.e. create a trigger when a value change but not in the base record but in a related record.

JOB_TRIGR1_ESP

(SQL Table)

Trigger creation work table

Work table to create Job GP triggers. Special table to create triggers under special situations, i.e. create a trigger when a value change but not in the base record but in a related record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

3 EFFDT Date(10) DATE Effective Date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 RIGHTS_LOST_ESP Character(2) VARCHAR2(2) NOT NULL AFI - Rights Lost

6 LABOR_RLTNSHIP_ESP Character(4) VARCHAR2(4) NOT NULL Special Labor Relationship

7 FAMILY_BOND_ESP Character(1) VARCHAR2(1) NOT NULL Family Bond
1=Family Member up to Second Deg
3=Descendant younger than 30 yrs
4=Family Member younger than 45
5=Child with qualif. Disability
9=Resp Dec Non-exist Family Ties
I=Child <30 years Law 6/2017
J=Fam Mem up to 2nd Deg L6/2017
K=Child 30 Qualif Disab L 6/2017

8 SOC_SEC_WRK_GRP_CD Character(2) VARCHAR2(2) NOT NULL Social Security Work Group
01=01-Engineers
02=02-Technicals
03=03-Administrative
04=04-Assistants
05=05-White Collar
06=06-Subordinates
07=07-Administrative assistants
08=08-1st and 2nd degree
09=09-3rd degree
10=10-Over 18 years
11=11-Under 18 years

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

10 ACTION_FLAG Character(2) VARCHAR2(2) NOT NULL Action Flag

11 PREV_EFFDT Date(10) DATE Work field

12 PRIOR_EFFSEQ Number(3,0) SMALLINT NOT NULL Prior Effective Sequence

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE	Effective Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	RIGHTS_LOST_ESP	Character(2)	VARCHAR2(2) NOT NULL	AFI - Rights Lost
6	LABOR_RLTNSHIP_ESP	Character(4)	VARCHAR2(4) NOT NULL	Special Labor Relationship
7	FAMILY_BOND_ESP	Character(1)	VARCHAR2(1) NOT NULL	Family Bond 1=Family Member up to Second Deg 3=Descendant younger than 30 yrs 4=Family Member younger than 45 5=Child with qualif. Disability 9=Resp Dec Non-exist Family Ties I=Child <30 years Law 6/2017 J=Fam Mem up to 2nd Deg L6/2017 K=Child 30 Qualif Disab L 6/2017
8	SOC_SEC_WRK_GRP_CD	Character(2)	VARCHAR2(2) NOT NULL	Social Security Work Group 01=01-Engineers 02=02-Technicals 03=03-Administrative 04=04-Assistants 05=05-White Collar 06=06-Subordinates 07=07-Administrative assistants 08=08-1st and 2nd degree 09=09-3rd degree 10=10-Over 18 years 11=11-Under 18 years
9	CONTRACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Contract Type
10	ACTION_FLAG	Character(2)	VARCHAR2(2) NOT NULL	Action Flag
11	PREV_EFFDT	Date(10)	DATE	Work field
12	PRIOR_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Prior Effective Sequence