HRS_STS_TBL_I

(SQL View)
 Index Back

Status Table Interface

Status Table Interface

SELECT STATUS_AREA , STATUS_CODE , DESCR , DESCRSHORT , OPEN_STS_IND , STATUS_PHASE , MUTUALLY_EXCLUSIVE , DEFAULT_STS_IND , COMPLETE_STS_IND , DATA_TYPE_CD , HRS_DRFT_STS_IND , HRS_APRV_STS_IND , HRS_DND_APRV_IND , HRS_DFLT_APRV_IND , HRS_NOTIF_IND , HRS_WITHDRAW_IND , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_STS_TBL A

  • Related Language Record: HRS_STS_TBL_LNI

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STATUS_AREA Character(1) VARCHAR2(1) NOT NULL Defines an area in the system that track statuses.
    1=1-Job Opening
    2=2-Applicant
    3=3-Recruitment Summary
    4=4-Route
    5=5-Interview
    6=6-Offer
    2 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 OPEN_STS_IND Character(1) VARCHAR2(1) NOT NULL Indicates an open state.

    Y/N Table Edit

    Default Value: Y

    6 STATUS_PHASE Character(1) VARCHAR2(1) NOT NULL Identifies a phase within a status area.
    1=1-Applied
    2=2-Reviewed
    3=3-Screen
    4=4-Route
    5=5-Interview
    6=6-Offer
    7=7-Hire
    8=8-Hold
    9=9-Reject
    7 MUTUALLY_EXCLUSIVE Character(1) VARCHAR2(1) NOT NULL Indicates a mutually exclusive state.

    Y/N Table Edit

    Default Value: N

    8 DEFAULT_STS_IND Character(1) VARCHAR2(1) NOT NULL Indicates that default status.

    Y/N Table Edit

    Default Value: N

    9 COMPLETE_STS_IND Character(1) VARCHAR2(1) NOT NULL Indicates a complete and successful status.

    Y/N Table Edit

    Default Value: N

    10 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N

    11 HRS_DRFT_STS_IND Character(1) VARCHAR2(1) NOT NULL Draft Status Indicator
    12 HRS_APRV_STS_IND Character(1) VARCHAR2(1) NOT NULL Approval Status Indicator
    13 HRS_DND_APRV_IND Character(1) VARCHAR2(1) NOT NULL Approval Denied Indicator
    14 HRS_DFLT_APRV_IND Character(1) VARCHAR2(1) NOT NULL Approval Default Indicator
    15 HRS_NOTIF_IND Character(1) VARCHAR2(1) NOT NULL Notification
    16 HRS_WITHDRAW_IND Character(1) VARCHAR2(1) NOT NULL Indicates applicant can withdraw an application in the given status.
    17 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    18 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    19 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    20 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id