PROCESS_INSTANCELAST_HIRE_DTTERMINATION_DTEMPLIDEMPL_RCDEFFDTDefault Value: %date
EFFSEQDATE_YEAR_VALDATE_MONTH_VAL01=Calendar Days
02=30 days Monthly Basis
1=Monthly
2=Fortnightly
3=Weekly
4=Daily
5=Hourly
6=Per Task
7=Commission
8=Other
GPBR_H08_TMP(SQL Table) |
Index Back |
|---|---|
Homolognet Temporary Table 08Homolognet Temporary Table 08 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | LAST_HIRE_DT |
Date(10) | DATE | Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD. |
| 3 | TERMINATION_DT |
Date(10) | DATE | Termination Date |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 6 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 7 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 8 | DATE_YEAR_VAL |
Number(4,0) | SMALLINT NOT NULL | Date Year Value |
| 9 | DATE_MONTH_VAL |
Number(2,0) | SMALLINT NOT NULL | Date Month Value |
| 10 | GPBR_SALARY_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Salary Type for GP Brazil
01=Calendar Days 02=30 days Monthly Basis |
| 11 | GPBR_FIX_SAL_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Fixed Salary Type |
| 12 | CONT_SAL_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Contract Salary Type Brazil
1=Monthly 2=Fortnightly 3=Weekly 4=Daily 5=Hourly 6=Per Task 7=Commission 8=Other |