HRS_JO_TEAM_HST

(SQL Table)
 Index Back

Job Opeing Team

Job Opeing Team

  • Parent record: HRS_JOB_OPENING

    • # 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_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

    Prompt Table: HRS_JOB_OPENING

    4 HRS_JO_TM_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Team Type
    A=Approver/Reviewer
    G=Originator
    I=Interviewer
    M=Manager
    O=Interested Party
    R=Recruiter
    S=Screening Team
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: HRS_PERSON_NM_I

    6 HRS_JO_TM_PRIMARY Character(1) VARCHAR2(1) NOT NULL Team Primary
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    7 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    8 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    9 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    10 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id