HRS_APP_MBR_VW1

(SQL View)
 Index Back

Applicant Memberships

Applicant Memberships

SELECT A.HRS_PERSON_ID ,A.HRS_PROFILE_SEQ ,A.HRS_APP_ACMP_ID ,A.ACCOMPLISHMENT ,A.DT_ISSUED ,A.MAJOR_CODE ,B.ACCOMP_CATEGORY ,B.DESCR , %subrec(MEMBERSHIP_SBR,A) FROM PS_HRS_APP_ACMP A , PS_HRS_ACCOM_TBL_I B WHERE A.ACCOMPLISHMENT = B.ACCOMPLISHMENT AND B.ACCOMP_CATEGORY = 'MEM'

  • Related Language Record: HRS_APP_MBR_LVW

  • Parent record: HRS_APP_PROFILE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    3 HRS_APP_ACMP_ID Number(15,0) DECIMAL(15) NOT NULL Accomplishment ID
    4 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: %RECNAME_EDIT

    5 DT_ISSUED Date(10) DATE Issue Date
    6 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code

    Prompt Table: MAJOR_TBL

    7 ACCOMP_CATEGORY Character(3) VARCHAR2(3) NOT NULL Accomplishment Category
    DEG=Degree
    HON=Honor or Award
    LIC=License or Certification
    LNG=Language
    MEM=Membership
    NVQ=NVQ
    TST=Test
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 MANDATE Character(15) VARCHAR2(15) NOT NULL Mandate
    10 MANDATE_FUNCTION Character(15) VARCHAR2(15) NOT NULL Mandate Position
    11 MANDATE_BEGIN_DATE Date(10) DATE Mandate Begin Date
    12 MANDATE_END_DATE Date(10) DATE Mandate End Date