HRS_JO_POSN_I

(SQL View)
 Index Back

Job Opening Positions Intfc

Job opening positions interface view

SELECT A.HRS_JOB_OPENING_ID , A.POSITION_NBR , B.DESCR , B.JOBCODE , A.HRS_JO_PRM_PSN_FLG , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_JO_POSN A , PS_HRS_POS_DTA_C_I B WHERE A.POSITION_NBR = B.POSITION_NBR AND B.EFFDT=( SELECT MAX(EFFDT) FROM PS_HRS_POS_DTA_C_I C WHERE C.POSITION_NBR=B.POSITION_NBR AND C.EFFDT<= %DateIn('9999-09-09'))

  • Related Language Record: HRS_JO_PSN_LN_I

  • Parent record: HRS_JO_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

    Prompt Table: HRS_JO_I

    2 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: HRS_POS_DTA_C_I

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: HRS_JOBCODE_I

    5 HRS_JO_PRM_PSN_FLG Character(1) VARCHAR2(1) NOT NULL Primary position number for job opening
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

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