HRS_APP_CNTRACT

(SQL Table)
 Index Back

Contract Info for Applicant

Details of the employment contract of Applicants.

  • Related Language Record: HRS_APP_CNT_LNG

  • Parent record: HRS_APPLICANT

    • # 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

    Default Value: %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

    Default Value: A

    7 ADD_CONTRACT Character(1) VARCHAR2(1) NOT NULL Additional Contract

    Y/N Table Edit

    Default Value: N

    8 CNT_MIN_HRS Number(6,2) DECIMAL(5,2) NOT NULL Minimum Hours Per Contract

    Default Value: BUS_UNIT_OPT_HR.MIN_STD_HRS

    9 CNT_MAX_HRS Number(6,2) DECIMAL(5,2) NOT NULL Maximum Hours Per Contract

    Default Value: BUS_UNIT_OPT_HR.MAX_STD_HRS

    10 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID

    Prompt Table: HRS_PERSON_NM_I

    11 YEAR_SW Character(1) VARCHAR2(1) NOT NULL More than one year expected

    Y/N Table Edit

    Default Value: N

    12 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
    13 CNT_TEMPLATE_ID Character(11) VARCHAR2(11) NOT NULL Contract Template ID

    Prompt Table: HRS_CNT_TMP_VW

    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

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: REG_STANDARD_VW

    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