LOC_CASEOFF_GER

(SQL Table)
 Index Back

H&S - Location CaseOfficer

Child record for LOC_CASEOFF_TBL - lists the emplids that are caseofficers for a particular location.

  • Parent record: LOC_CASEOFF_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

    2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON_NAME

    5 OFFICER_TYPE_GER Character(3) VARCHAR2(3) NOT NULL Officer Type
    AOB=Health And Safety Rep.
    ARZ=Company Physician
    NUC=Radiation Protection Rep.
    RAD=Laser Protection Rep.
    SEC=Health And Safety Specialist