HRS_APP_CTR_HST

(SQL Table)
 Index Back

Contract Info for Applicant

Details of the employment contract of Applicants.

  • Parent record: HRS_APPLICANT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    5 CONTRACT_BEGIN_DT Date(10) DATE Contract Begin Date

    Default Value: %Date

    6 CONTRACT_END_DT Date(10) DATE Contract End Date
    7 SIGNATURE_DT Date(10) DATE Signature Date
    8 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

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: BUS_UNIT_OPT_HR.MIN_STD_HRS

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

    Default Value: BUS_UNIT_OPT_HR.MAX_STD_HRS

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

    Prompt Table: PERSON_NAME

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

    Y/N Table Edit

    Default Value: N

    14 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
    15 CNT_TEMPLATE_ID Character(11) VARCHAR2(11) NOT NULL Contract Template ID

    Prompt Table: CNT_TEMPL_VW

    16 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

    17 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

    18 HIRE_CTR_CD_ESP Character(3) VARCHAR2(3) NOT NULL Hiring Center

    Prompt Table: HRS_HIRCT_ESP_I

    19 COMP_RATE_DESCR Character(100) VARCHAR2(100) NOT NULL Compensation Rate Description
    20 PROBATION_PERIOD Number(3,0) SMALLINT NOT NULL Probation Period
    21 DURATION_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Duration
    D=Days
    M=Months
    Y=Years

    Default Value: M

    22 VACATION_PERIOD Number(3,0) SMALLINT NOT NULL Vacation Period
    23 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

    24 SCHEME_ID_ESP Character(4) VARCHAR2(4) NOT NULL Scheme ID - ESP

    Prompt Table: HRS_SCRGM_ESP_I

    25 CONTRIB_ID_ESP Character(5) VARCHAR2(5) NOT NULL Soc.Sec. Contribution ID - ESP

    Prompt Table: HRS_RGM_ESP_1_I

    26 ACTIVE_RENT_ESP Character(1) VARCHAR2(1) NOT NULL Social Security Active Rent

    Y/N Table Edit

    Default Value: N

    27 FIRST_SELFWRKR_ESP Character(1) VARCHAR2(1) NOT NULL First self employer worker

    Y/N Table Edit

    Default Value: N

    28 PART_TIME_PERC_ESP Number(3,0) SMALLINT NOT NULL Percentage of Part Time
    29 RE_JOIN_DSB_EE_ESP Character(1) VARCHAR2(1) NOT NULL Re-Joined Disabled Employee

    Y/N Table Edit

    Default Value: N

    30 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
    31 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
    32 CONTRCT_EXP_END_DT Date(10) DATE Contract Expected End Date
    33 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: REG_STANDARD_VW

    34 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type

    Prompt Table: HRS_PER_CNTYP_I

    35 EXTEND_CONTRACT_SW Character(1) VARCHAR2(1) NOT NULL Extend Contract

    Y/N Table Edit

    Default Value: N

    36 RSN_DET_CONTRACT Character(1) VARCHAR2(1) NOT NULL Reason for Determine Period
    M=Maternity
    N=Not Applicable
    P=Special Project
    R=Replacement
    37 EMPLID_REPLACED Character(11) VARCHAR2(11) NOT NULL Empl ID Replaced

    Prompt Table: PERSON_NAME

    38 PROJECT_NAME Character(30) VARCHAR2(30) NOT NULL Displays the Project names.
    39 PLAN_ID_ITA Character(1) VARCHAR2(1) NOT NULL Plan ID
    S=Sales Plan
    T=Technical Plan
    40 DURATION_MONTH Number(3,0) SMALLINT NOT NULL Duration (Months)
    41 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

    Prompt Table: EMPL_CTG

    42 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category

    Prompt Table: EMPL_CTG_L1

    43 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory

    Prompt Table: EMPL_CTG_L2

    44 EMPL_CTG_L2 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory 2

    Prompt Table: EMPL_CTG_L3

    45 PROBATION_DT Date(10) DATE Probation Date
    46 PROBATN_REASON Character(2) VARCHAR2(2) NOT NULL New Probation Reason
    01=Unsatisfactory Performance
    02=New Date Needed
    47 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    48 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    49 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    50 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    51 COMMENTS Long Character CLOB Comment