HRS_APP_DEG_VW

(SQL View)
 Index Back

Applicant Degree

Applicant Degree

SELECT A.HRS_PERSON_ID ,A.HRS_PROFILE_SEQ ,A.HRS_APP_ACMP_ID ,A.ACCOMPLISHMENT ,A.DT_ISSUED ,A.MAJOR_CODE , %subrec(HRS_TESTS_SBR,A) , %subrec(HRS_LICCERT_SBR,A) , %subrec(HRS_LNG_SBR,A) , %subrec(HRS_MBR_SBR,A) , %subrec(HRS_EDU_SBR,A) , %subrec(HRS_EDUGER_SBR,A) , %subrec(HRS_HA_SBR,A) , %subrec(HRS_HAFRA_SBR,A) ,%subrec(HRS_EDUFED_SBR,A) ,%subrec(HRS_EDUFPS_SBR,A) ,%subrec(HRS_EDUJPN_SBR,A) ,A.ACCOMPLISHMENT_TXT ,A.EVALUATION_TYPE ,A.GVT_HAS_ACCOMP ,A.HRS_EXT_ACMP_CTG ,%subrec(HRS_MIL_RS_SBR,A) ,%subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_APP_ACMP A WHERE EXISTS ( SELECT 'X' FROM PS_HRS_ACCOM_TBL_I B WHERE A.ACCOMPLISHMENT = B.ACCOMPLISHMENT AND B.ACCOMP_CATEGORY = 'DEG') OR HRS_EXT_ACMP_CTG='DEG'

  • Related Language Record: HRS_APP_DEG_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: HRS_PROF_DEG_VW

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

    Prompt Table: HRS_MAJOR_I

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: STATE_TBL

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

    Prompt Table: COUNTRY_TBL

    13 EXPIRATN_DT Date(10) DATE Expiration Date
    14 LICENSE_VERIFIED Character(1) VARCHAR2(1) NOT NULL License Verified

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    19 SPEAK_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Speaking Proficiency
    1=Low
    2=Moderate
    3=High

    Default Value: 1

    20 READ_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Reading Proficiency
    1=Low
    2=Moderate
    3=High

    Default Value: 1

    21 WRITE_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Writing Proficiency
    1=Low
    2=Moderate
    3=High

    Default Value: 1

    22 EVALUATION_DT Date(10) DATE Evaluation Date
    23 MANDATE Character(15) VARCHAR2(15) NOT NULL Mandate
    24 MANDATE_FUNCTION Character(15) VARCHAR2(15) NOT NULL Mandate Position
    25 MANDATE_BEGIN_DATE Date(10) DATE Mandate Begin Date
    26 MANDATE_END_DATE Date(10) DATE Mandate End Date
    27 MAJOR Character(30) VARCHAR2(30) NOT NULL Major
    28 IPE_SW Character(1) VARCHAR2(1) NOT NULL Intern. Professional Education

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: %EDITTABLE

    33 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    34 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: HCR_STONLY_OT_I

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

    Prompt Table: COUNTRY_TBL

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

    Y/N Table Edit

    Default Value: N

    37 PRACTIC_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Practical Grade
    38 THEORY_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Theoretical Grade
    39 GRANTOR Character(20) VARCHAR2(20) NOT NULL The name of the person granting the award
    40 END_DATE Date(10) DATE End Date
    41 BONUS_DT_FRA Date(10) DATE Bonus Date
    42 BONUS_AMOUNT_FRA Number(8,2) DECIMAL(7,2) NOT NULL Bonus
    43 GVT_CREDIT_HOURS Character(3) VARCHAR2(3) NOT NULL Credit Hours
    44 GVT_CRED_HRS_TYPE Character(1) VARCHAR2(1) NOT NULL Credit Hours Type
    C=Continuing Education
    O=Other Pay
    Q=Quarter Hours
    S=Semester Hours
    45 GPA Number(5,2) DECIMAL(4,2) NOT NULL GPA
    46 YR_ACQUIRED Number(4,0) SMALLINT NOT NULL Year Acquired
    47 FP_SUBJECT_CD Character(3) VARCHAR2(3) NOT NULL Subject

    Prompt Table: FPMSUBJECTS

    48 FACULTY_CODE Character(10) VARCHAR2(10) NOT NULL Faculty Code (Japan HR)

    Prompt Table: FACULTY_TBL_JPN

    49 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    50 SUBFACULTY_CODE Character(10) VARCHAR2(10) NOT NULL Sub Faculty Code(Japan HR)

    Prompt Table: SBFCLTY_TBL_JPN

    51 SUBFACULTY_NAME Character(50) VARCHAR2(50) NOT NULL Sub Faculty Name(Description)(Japan HR)
    52 MAJOR_CATEGORY Character(1) VARCHAR2(1) NOT NULL Major Category(Japan HR)
    H=Humanities
    S=Sciences
    53 ACCOMPLISHMENT_TXT Character(30) VARCHAR2(30) NOT NULL Accomplishment Text
    54 EVALUATION_TYPE Character(1) VARCHAR2(1) NOT NULL Evaluation Type
    A=Approved/Official
    B=Subordinate
    C=Customer
    E=Executive Committee
    L=Learning
    M=Mentor
    P=Peer
    R=Supervisor/Manager
    S=Self
    55 GVT_HAS_ACCOMP Character(1) VARCHAR2(1) NOT NULL Has Met Accomplishment Requirement
    56 HRS_EXT_ACMP_CTG Character(3) VARCHAR2(3) NOT NULL External Applicant Accomplishment Category.Identifies the type of applicant accomplishment when loaded from an external data source.
    DEG=Degree
    HON=Honor or Award
    LIC=License or Certification
    LNG=Language
    MEM=Membership
    NVQ=NVQ
    TST=Test
    57 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service
    58 MIL_RANK Character(5) VARCHAR2(5) NOT NULL Military Rank
    59 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    60 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    61 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    62 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id