UPG_HRS_APP_CNT(SQL Table) |
Index Back |
|---|---|
TmpContract Info for Applicanttemp table for details of the employment contract of Applicants. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 3 | CONTRACT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 4 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |
| 5 | SIGNATURE_DT | Date(10) | DATE | Signature Date |
| 6 | CONTRACT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Contract Status -
The values 'N - N/A' and 'P - Pending' are suppressed from release 8.
A=Active I=Inactive |
| 7 | ADD_CONTRACT | Character(1) | VARCHAR2(1) NOT NULL | Additional Contract |
| 8 | CNT_MIN_HRS | Number(6,2) | DECIMAL(5,2) NOT NULL | Minimum Hours Per Contract |
| 9 | CNT_MAX_HRS | Number(6,2) | DECIMAL(5,2) NOT NULL | Maximum Hours Per Contract |
| 10 | RESPONSIBLE_ID | Character(11) | VARCHAR2(11) NOT NULL | Responsible ID |
| 11 | YEAR_SW | Character(1) | VARCHAR2(1) NOT NULL | More than one year expected |
| 12 | COMMENTSHORT | Character(30) | VARCHAR2(30) NOT NULL | Short Comment |
| 13 | CNT_TEMPLATE_ID | Character(11) | VARCHAR2(11) NOT NULL | Contract Template ID |
| 14 | BEGIN_WEEKDAY | Character(1) | VARCHAR2(1) NOT NULL |
Begin/End Week
1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday Default Value: 2 |
| 15 | END_WEEKDAY | Character(1) | VARCHAR2(1) NOT NULL |
End Day of Week
1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday Default Value: 6 |
| 16 | HIRE_CTR_CD_ESP | Character(3) | VARCHAR2(3) NOT NULL |
Hiring Center
Prompt Table: HRS_HIRCT_ESP_I |
| 17 | COMP_RATE_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Compensation Rate Description |
| 18 | PROBATION_PERIOD | Number(3,0) | SMALLINT NOT NULL | Probation Period |
| 19 | DURATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Duration
D=Days M=Months Y=Years Default Value: M |
| 20 | VACATION_PERIOD | Number(3,0) | SMALLINT NOT NULL | Vacation Period |
| 21 | VACN_PERIOD_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Vacation Period Type
D=Work Days M=Months N=Natural Days W=Weeks Default Value: M |
| 22 | SCHEME_ID_ESP | Character(4) | VARCHAR2(4) NOT NULL |
Scheme ID - ESP
Prompt Table: HRS_SCRGM_ESP_I |
| 23 | CONTRIB_ID_ESP | Character(5) | VARCHAR2(5) NOT NULL |
Soc.Sec. Contribution ID - ESP
Prompt Table: HRS_RGM_ESP_1_I |
| 24 | ACTIVE_RENT_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Social Security Active Rent
Y/N Table Edit Default Value: N |
| 25 | FIRST_SELFWRKR_ESP | Character(1) | VARCHAR2(1) NOT NULL |
First self employer worker
Y/N Table Edit Default Value: N |
| 26 | PART_TIME_PERC_ESP | Number(3,0) | SMALLINT NOT NULL | Percentage of Part Time |
| 27 | RE_JOIN_DSB_EE_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Re-Joined Disabled Employee
Y/N Table Edit Default Value: N |
| 28 | SOC_EXCLUSION_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Social Exclusion Employee
0=None 1=Social Exclusion 2=Domestic Violence Victim 3=Gender Violence Victim 4=Soc Excl - Insertion Itinerary 5=Soc Excl - Relapse |
| 29 | UNEMPLYMNT_CND_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Unemployment Condition
1=Booked in Unemployment Office 2=Booked in Office more than 12 3=Agricultural 4=With subsidy over one year 5=Booked in Office more than 6 m 6=With One-yr-remaining Subsidy 7=W/ subsidy. Older than 52 yrs. A=W/ Benefit. RDL 2/2009 B=With Employability Problems C=Unemployed at 1-1-2011 D=Unemployed at 1-1-2011. 12/18 E=Unemployed 16-08-2011 F=Unemployed with Family support G=Unemployed >6 m. Fam Support H=Under 3 m. of work experience I=Unemployed from another sector J=Youth Employment K=Unemployed w/o Education Certf M=Part Time<333. RDL 2/2009 P=RDL 3/2014 - Fix rate R=RDL 1/2015 Reduced rate |
| 30 | CONTRCT_EXP_END_DT | Date(10) | DATE | Contract Expected End Date |
| 31 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 32 | CONTRACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Contract Type
Prompt Table: HRS_PER_CNTYP_I |
| 33 | EXTEND_CONTRACT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Extend Contract
Y/N Table Edit Default Value: N |
| 34 | RSN_DET_CONTRACT | Character(1) | VARCHAR2(1) NOT NULL |
Reason for Determine Period
M=Maternity N=Not Applicable P=Special Project R=Replacement |
| 35 | EMPLID_REPLACED | Character(11) | VARCHAR2(11) NOT NULL |
Empl ID Replaced
Prompt Table: PERSON_NAME |
| 36 | PROJECT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Displays the Project names. |
| 37 | PLAN_ID_ITA | Character(1) | VARCHAR2(1) NOT NULL |
Plan ID
S=Sales Plan T=Technical Plan |
| 38 | DURATION_MONTH | Number(3,0) | SMALLINT NOT NULL | Duration (Months) |
| 39 | LABOR_AGREEMENT | Character(6) | VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table: EMPL_CTG |
| 40 | EMPL_CTG | Character(6) | VARCHAR2(6) NOT NULL |
Employee Category
Prompt Table: EMPL_CTG_L1 |
| 41 | EMPL_CTG_L1 | Character(6) | VARCHAR2(6) NOT NULL |
Employee Subcategory
Prompt Table: EMPL_CTG_L2 |
| 42 | EMPL_CTG_L2 | Character(6) | VARCHAR2(6) NOT NULL |
Employee Subcategory 2
Prompt Table: EMPL_CTG_L3 |
| 43 | PROBATION_DT | Date(10) | DATE | Probation Date |
| 44 | PROBATN_REASON | Character(2) | VARCHAR2(2) NOT NULL |
New Probation Reason
01=Unsatisfactory Performance 02=New Date Needed |
| 45 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 46 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 47 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 48 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |
| 49 | COMMENTS | Long Character | CLOB | Comment |
| 50 | APP_DT | Date(10) | DATE | Date an application was submitted |