UPG_SUBSRCE_LNG

(SQL Table)
 Index Back

  • Parent record: HRS_SOURCE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID
    2 REFERRAL_SOURCE Character(2) VARCHAR2(2) NOT NULL Referral Source
    AD=Advertisement
    AG=Agency
    CL=Client Referral
    CO=College Recruiting
    CR=College Recommendation
    EE=Employee
    ES=Employment Securitry Bureau
    FE=Former Employee
    JF=Job Fair
    JP=Job Posting
    OH=Open House
    OT=Other Source
    PI=Phone Inquiry
    UK=Unknown
    US=Unsolicited
    WI=Walk-In
    XR=Executive Referral
    XS=Executive Search
    3 EFFDT Date(10) DATE Effective Date
    4 HRS_SUBSOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Subsource Id
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 HRS_SUBSOURCE_DESC Character(50) VARCHAR2(50) NOT NULL Subsource Description