HR_CPGVTJOB_VW

(SQL View)
 Index Back

CP IDP GVT Job view

Data used for Career Planning Individual Development Plan report.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.DEPTID , A.POSITION_NBR , A.JOBCODE , A.REG_TEMP , ' ' , A.GVT_WORK_SCHED , ' ' , A.GRADE_ENTRY_DT , A.SETID_DEPT , ' ' , A.SETID_LOCATION , A.SETID_JOBCODE , A.LOCATION , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_GVT_JOB A

  • Parent record: PER_ORG_ASGN_VW

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

    Default Value: NEW

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

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

    Prompt Table: POSITION_DATA

    7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    8 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary

    Default Value: R

    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 GVT_WORK_SCHED Character(1) VARCHAR2(1) NOT NULL Work Schedule
    B=Baylor Plan
    F=Full Time
    G=Full Time Seasonal
    I=Intermittent
    J=Intermittent-Seasonal
    P=Part Time
    Q=Part-Time Seasonal
    R=Part-Time Phased Retiree
    S=Part-Time Job Sharer
    T=Part-Time Seasonal Job Sharer
    11 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    12 GRADE_ENTRY_DT Date(10) DATE Grade Entry Date
    13 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    14 DESCR6 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
    15 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    16 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    17 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    18 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    19 FULL_NAME Character(120) VARCHAR2(120) NOT NULL Full Name
    20 CITY Character(30) VARCHAR2(30) NOT NULL City
    21 STATE Character(6) VARCHAR2(6) NOT NULL State
    22 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country