| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
CONTRACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Type
Prompt Table:
PERS_CNTRCT_TYP
|
| 5 |
EXTEND_CONTRACT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Extend Contract
Y/N Table Edit
Default Value: N
|
| 6 |
RSN_DET_CONTRACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reason for Determine Period
M=Maternity
N=Not Applicable
P=Special Project
R=Replacement
|
| 7 |
EMPLID_REPLACED |
Character(11) |
VARCHAR2(11) NOT NULL |
Empl ID Replaced
Prompt Table:
PERSON_NAME
|
| 8 |
PROJECT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Displays the Project names.
|
| 9 |
PLAN_ID_ITA |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan ID
S=Sales Plan
T=Technical Plan
|
| 10 |
DURATION_MONTH |
Number(3,0) |
SMALLINT NOT NULL |
Duration (Months)
|
| 11 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
EMPL_CTG
|
| 12 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
Prompt Table:
EMPL_CTG_L1
|
| 13 |
EMPL_CTG_L1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory
Prompt Table:
EMPL_CTG_L2
|
| 14 |
EMPL_CTG_L2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory 2
Prompt Table:
EMPL_CTG_L3
|
| 15 |
CATEGORY_CD_GPFRA |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used as a System Element in Global Payroll. It is a French specific field.
A=Apprentice
C=Manager
D=Executive
|
| 16 |
CLNG_CALPRCT_GPFRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
This field is used as a System Element in Global Payroll. It is a French specific field.
Default Value: 100
|
| 17 |
EMPL_CNDTN_GPFRA |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is used as a System Element in Global Payroll. It is a French specific field.
01=Full Time
02=Part Time (without L242-8)
04=Periodic Worker
05=Worker At Home
06=Seasonal Worker
07=Temporary Worker
08=Occasional Worker
90=No Additional Contract
|
| 18 |
REDUC_PRCT_GPFRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
This field is used as a System Element in Global Payroll. It is a French specific field.
|
| 19 |
SS_REGIM_CD_GPFRA |
Number(3,0) |
SMALLINT NOT NULL |
This field is used as a System Element in Global Payroll. It is a French specific field.
Prompt Table:
GPFR_URS_RATES
|
| 20 |
EE_PROF_STATUS_FRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Employee Professional Status - FRA
Prompt Table:
PRF_STS_FRA_TBL
|
| 21 |
CTG_STATUS_FRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Category Status - FRA
Prompt Table:
CTG_STS_FRA_TBL
|
| 22 |
BASE_SCHEME_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Mandatory Base Scheme
Prompt Table:
BSE_SCH_FRA_TBL
|
| 23 |
STATUTE_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Statute
Prompt Table:
STATUTE_TBL_BEL
|
| 24 |
SUBSTATUTE_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Substatute
00=Not Applicable
01=Regular Employee
02=Sales Representative
03=Executive
Prompt Table:
SUBSTAT_BEL_VW
|
| 25 |
CONTR_DUR_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Duration
01=Indefinite duration
02=Temporary duration
03=Defined work
04=Replacement
|
| 26 |
INDEP_OCCUP_BEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Indep. Profession
|
| 27 |
PROFESSION_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Profession
01=Architects
02=Lawyers
03=Bookkeepers
04=Dentists
05=Physicians and surgeons
06=Veterinarians
07=Accountants
08=Surveyors
09=Bailiffs
10=Physiotherapists
11=Notaries
12=Chemists
13=Auditors
|