HIRING_CTR_ESP

(SQL Table)
Index Back

Hiring Center

Hiring Center

  • Related Language Record: HIRG_CTR_ESPLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HIRE_CTR_CD_ESP Character(3) VARCHAR2(3) NOT NULL Hiring Center
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    7 REPRESNT_ID_ESP Character(11) VARCHAR2(11) NOT NULL Company Representative ID

    Prompt Table: REPRESNTATV_ESP

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

    Prompt Table: PERSON

    9 RESPONSIBLE_ROLE Character(30) VARCHAR2(30) NOT NULL Responsible Role
    10 CITY_CD_ESP Character(5) VARCHAR2(5) NOT NULL City Code

    Prompt Table: CITY_ESP_VW

    11 SIGNATURE_CITY Character(30) VARCHAR2(30) NOT NULL Signature City
    12 EMPLMNT_OFF_CD_ESP Character(8) VARCHAR2(8) NOT NULL Employment Office Code.

    Prompt Table: SEPE_ESP_VW

    13 UNEMPLOYMNT_OFFICE Character(30) VARCHAR2(30) NOT NULL Employment Office