| # |
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.SETID
Prompt Table:
SET_VLD_HR_14
|
| 2 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
EMPL_CTG
|
| 3 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 7 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 8 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 9 |
CATEGORY_2483_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Category 24-83
AGM=Technician
CAD=Executive
EMP=Employee
ONQ=Non Qualified Worker
OQU=Qualified Worker
WRK=Worker
|
| 10 |
BILAN_STAT_CD_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Social Bilan Category
ASC=Acting Executive
CAD=Executive
EMN=Non Qualified Worker
EMQ=Qualified Worker
TEC=Technician
|
| 11 |
NBR_COLUMNS_FRA |
Number(1,0) |
SMALLINT NOT NULL |
Number of Columns
|
| 12 |
DESCR1_FRA |
Character(10) |
VARCHAR2(10) NOT NULL |
Column 1 Description
|
| 13 |
DESCR2_FRA |
Character(10) |
VARCHAR2(10) NOT NULL |
Column 2 Description
|
| 14 |
DESCR3_FRA |
Character(10) |
VARCHAR2(10) NOT NULL |
Column 3 Description
|
| 15 |
DESCR4_FRA |
Character(10) |
VARCHAR2(10) NOT NULL |
Column 4 Description
|
| 16 |
DESCR5_FRA |
Character(10) |
VARCHAR2(10) NOT NULL |
Column 5 Description
|
| 17 |
CATEGORY_FORCEM |
Character(3) |
VARCHAR2(3) NOT NULL |
FORCEM Category
1=Manager
2=Middle Level Manager
3=Technical
4=Qualified Worker
5=No Qualified Worker
|
| 18 |
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
Prompt Table:
WRK_GRP_ESP_VW
|
| 19 |
SCHEME_ID_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Scheme ID - ESP
Prompt Table:
SCHEME_ESP_VW
|
| 20 |
AGREEMENT_END_DT |
Date(10) |
DATE |
Agreement End Date
|
| 21 |
COMMENTS |
Long Character |
CLOB |
Comment
|