TR_CONT_HD_BRA

(SQL Table)
Index Back

Contract Trainee

Contract Trainee

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 BEGIN_DT Date(10) DATE NOT NULL Begin Date
4 END_DT Date(10) DATE NOT NULL end date
5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
6 PER_END_DT_BRA Date(10) DATE Period End Date -- Vacations Brazil
7 AP_VAC_STATUS_BRA Character(2) VARCHAR2(2) NOT NULL Acquisitive Period Status
01=In Progress
02=Open
03=Close per Absence
04=Close Expired
05=Close

Default Value: 02

8 SERVICE_MONTHS Number(4,1) DECIMAL(3,1) NOT NULL Months of Service
9 CALC_DAYS_BRA Number(3,0) SMALLINT NOT NULL Calculated Vacation Days GP Brazil
10 MAX_VAC_PER_BRA Number(2,0) SMALLINT NOT NULL Maximum Vacation Days per Period
11 ADJ_DAYS_BRA Signed Number(4,0) DECIMAL(3) NOT NULL Leave Days Brazil
12 UPD_TYPE_BRA Character(2) VARCHAR2(2) NOT NULL Updater Type Online or Batch
10=On Line
20=Batch
13 ORIG_BEGIN_DT Date(10) DATE original begin date