FO_EMP_MEM_VW

(SQL View)
 Index Back

Staffing Applicant Membship VW

Staffing Front Office Applicant Membership View SELECT A.EMPLID , A.ACCOMPLISHMENT , A.DT_ISSUED , A.MAJOR_CODE , %subrec(TESTS_SBR,A) , %subrec(LIC_CERT_SBR,A) , %subrec(LANGUAGE_SBR,A) , %subrec(MEMBERSHIP_SBR,A) , %subrec(EDUCATION_SBR,A) , %subrec(EDUCATN_GER_SBR,A) , %subrec(HONOR_AWARD_SBR,A) , %subrec(HONO_AW_FRA_SBR,A) , %subrec(EDUCATN_FED_SBR,A) FROM PS_ACCOMPLISHMENTS A WHERE A.ACCOMPLISHMENT IN ( SELECT B.ACCOMPLISHMENT FROM PS_ACCOMP_TBL B WHERE B.ACCOMP_CATEGORY = 'MEM')

SELECT A.EMPLID , A.ACCOMPLISHMENT , A.DT_ISSUED , A.MAJOR_CODE , %subrec(TESTS_SBR,A) , %subrec(LIC_CERT_SBR,A) , %subrec(LANGUAGE_SBR,A) , %subrec(MEMBERSHIP_SBR,A) , %subrec(EDUCATION_SBR,A) , %subrec(EDUCATN_GER_SBR,A) , %subrec(HONOR_AWARD_SBR,A) , %subrec(HONO_AW_FRA_SBR,A) , %subrec(EDUCATN_FED_SBR,A) FROM PS_ACCOMPLISHMENTS A WHERE A.ACCOMPLISHMENT IN ( SELECT B.ACCOMPLISHMENT FROM PS_ACCOMP_TBL B WHERE B.ACCOMP_CATEGORY = 'MEM')

  • Parent record: APPLICANT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: MEMBERSHIP_VW

    3 DT_ISSUED Date(10) DATE Issue Date
    4 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code

    Prompt Table: MAJOR_TBL

    5 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
    6 PASSED Character(1) VARCHAR2(1) NOT NULL Passed Test

    Y/N Table Edit

    Default Value: N

    7 LICENSE_NBR Character(15) VARCHAR2(15) NOT NULL License/Certification Number
    8 ISSUED_BY Character(30) VARCHAR2(30) NOT NULL Issued By
    9 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    11 EXPIRATN_DT Date(10) DATE Expiration Date
    12 LICENSE_VERIFIED Character(1) VARCHAR2(1) NOT NULL License Verified

    Y/N Table Edit

    Default Value: N

    13 RENEWAL Character(1) VARCHAR2(1) NOT NULL Renewal in Progress

    Y/N Table Edit

    Default Value: N

    14 NATIVE_LANGUAGE Character(1) VARCHAR2(1) NOT NULL Native Language

    Y/N Table Edit

    Default Value: N

    15 TRANSLATOR Character(1) VARCHAR2(1) NOT NULL Able to Translate

    Y/N Table Edit

    Default Value: N

    16 TEACHER Character(1) VARCHAR2(1) NOT NULL Able to Teach

    Y/N Table Edit

    Default Value: N

    17 SPEAK_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Speaking Proficiency
    1=Low
    2=Moderate
    3=High
    18 READ_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Reading Proficiency
    1=Low
    2=Moderate
    3=High
    19 WRITE_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Writing Proficiency
    1=Low
    2=Moderate
    3=High
    20 EVALUATION_DT Date(10) DATE Evaluation Date
    21 MANDATE Character(15) VARCHAR2(15) NOT NULL Mandate
    22 MANDATE_FUNCTION Character(15) VARCHAR2(15) NOT NULL Mandate Position
    23 MANDATE_BEGIN_DATE Date(10) DATE Mandate Begin Date
    24 MANDATE_END_DATE Date(10) DATE Mandate End Date
    25 MAJOR Character(30) VARCHAR2(30) NOT NULL Major
    26 IPE_SW Character(1) VARCHAR2(1) NOT NULL Intern. Professional Education

    Y/N Table Edit

    Default Value: N

    27 AVERAGE_GRADE Character(5) VARCHAR2(5) NOT NULL Average Grade
    28 EDUCATOR Character(50) VARCHAR2(50) NOT NULL Educator
    29 GRADUATE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Graduated

    Y/N Table Edit

    Default Value: Y

    30 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code

    Prompt Table: SCHOOL_TBL

    31 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    32 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: STATE_NAMES_OTH

    33 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

    Prompt Table: COUNTRY_TBL

    34 TERMINAL_DEGREE Character(1) VARCHAR2(1) NOT NULL Terminal Degree for Discipline

    Y/N Table Edit

    Default Value: N

    35 PRACTIC_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Practical Grade
    36 THEORY_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Theoretical Grade
    37 GRANTOR Character(20) VARCHAR2(20) NOT NULL Grantor
    38 END_DATE Date(10) DATE End Date
    39 BONUS_DT_FRA Date(10) DATE Bonus Date
    40 BONUS_AMOUNT_FRA Number(8,2) DECIMAL(7,2) NOT NULL Bonus
    41 GVT_CREDIT_HOURS Character(3) VARCHAR2(3) NOT NULL Credit Hours
    42 GVT_CRED_HRS_TYPE Character(1) VARCHAR2(1) NOT NULL Credit Hours Type
    43 GPA Number(5,2) DECIMAL(4,2) NOT NULL GPA
    44 YR_ACQUIRED Number(4,0) SMALLINT NOT NULL Year Acquired