FO_EMP_PRIWRK

(SQL Table)
 Index Back

App Prior Work Experience

Use PRIORWORK_EXPER to record an applicant's prior job experiences -- employers, locations, dates worked, type of position, and pay rate.

  • Parent record: APPLICANT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 START_DT Date(10) DATE NOT NULL Start Date
    3 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

    4 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
    5 CITY Character(30) VARCHAR2(30) NOT NULL City
    6 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

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

    Default Value: OPR_DEF_TBL_FS.LC_CNTRY

    Prompt Table: COUNTRY_TBL

    8 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
    BUSN=Business Phone
    CAMP=Campus Phone
    CELL=Cellular Phone
    DORM=Dormitory Phone
    FAX=FAX
    HOME=Home Phone
    MAIN=Main
    OTR=Other
    PGR1=Pager 1
    PGR2=Pager 2
    TELX=Telex
    9 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
    10 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    11 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
    12 END_DT Date(10) DATE End Date
    13 ENDING_TITLE Character(30) VARCHAR2(30) NOT NULL Ending Job Title
    14 ENDING_RATE Number(19,3) DECIMAL(18,3) NOT NULL Ending Pay Rate
    15 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
    B=Bi-weeky
    H=Hour
    M=Month
    Y=Year

    Default Value: M

    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    17 US_SOC_CD Character(6) VARCHAR2(6) NOT NULL Standard Occupational Classif
    18 CAN_NOC_CD Character(10) VARCHAR2(10) NOT NULL National Occupational Classif
    19 REL_WRK_EXPER Character(1) VARCHAR2(1) NOT NULL Relevant Work Experience

    Y/N Table Edit

    Default Value: Y

    20 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    21 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    F=Full-Time
    P=Part-Time
    22 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    23 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
    24 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
    25 GVT_TYPE_OF_APPT Character(2) VARCHAR2(2) NOT NULL Type of Appointment
    26 GVT_HOURS_PER_WEEK Number(4,1) DECIMAL(3,1) NOT NULL Hours Per Week
    27 GVT_POSN_OCCUPIED Character(1) VARCHAR2(1) NOT NULL Position Occupied
    28 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
    0=None
    1=Permanent
    2=Conditional
    3=Indefinite
    29 GVT_TYPE_OF_EXP Character(1) VARCHAR2(1) NOT NULL Experience Type
    30 DESCRLONG Long Character CLOB Long Description
    31 SUPERVISORS_NAME Character(40) VARCHAR2(40) NOT NULL Supervisor Name
    32 TERM_CODE Character(3) VARCHAR2(3) NOT NULL Termination Code
    01=Voluntary - No reason
    03=Voluntary - Changed Residence
    05=Voluntary - Disability/Illness
    07=Vol-Dissatisfaction-Co.Policy
    09=Vol-Dissatisfaction-Management
    11=Vol - Dissatisfaction-Perf Rev
    13=Vol - Dissatisfaction-Hours
    15=Vol - Dissatisfaction Comp
    17=Vol - Dissatisfaction-Conditns
    19=Vol - Dissatisfaction Other
    21=Voluntary - Lost Means of Tran
    23=Voluntary - Military Service
    25=Voluntary - Other
    27=Voluntary - Attend School
    29=Voluntary - Look for Other Wrk
    31=Voluntary - Personal/FamReason
    33=Invol-Destroyed/Lost Co.Assets
    35=Invol-Quality of Work
    37=Involuntary - Attendance
    39=Invol-Violated Co. Policy
    41=Invol-Violated Safety Rules
    43=Involuntary - Quality of Work
    45=Involuntary - Insubordination
    47=Involuntary - Other
    49=Involuntary - Not Work Related
    51=Involuntary - Layoff
    33 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    34 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    35 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments
    36 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

    Prompt Table: SP_SETID_NONVW

    37 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: FO_CUST_SET_VW

    38 RETURN_TO_EMP Character(1) VARCHAR2(1) NOT NULL Would Return to Employer

    Y/N Table Edit