HR_RMWRK_DAT

(SQL Table)
 Index Back

Job Data Temp Record

This temp record has been created to extract all the Job Data and remore request information for analytics

  • Related Language Record: HR_RW_SRCH_LNG

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

    Default Value: PER_ORG_ASGN.EMPLID

    Prompt Table: PERS_SRCH_GBL

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

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

    Prompt Table: JOBCODE_TBL

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

    Prompt Table: POSN_DATA_VW

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

    Default Value: R

    7 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time

    Default Value: F

    8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUSUNIT_HR_VW

    9 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
    CWR=Contingent Worker
    EMP=Employee
    POI=Person of Interest

    Default Value: PER_ORG_ASGN.PER_ORG

    10 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    11 HR_SRCH_POS_DESCR Character(30) VARCHAR2(30) NOT NULL Position Description
    12 HR_SRCH_LOC_DESCR Character(30) VARCHAR2(30) NOT NULL Location
    13 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: REG_STANDARD_VW

    14 HR_SRCH_DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department
    15 HR_SRCH_JBCD_DESCR Character(30) VARCHAR2(30) NOT NULL Job Title
    16 NAME Character(50) VARCHAR2(50) NOT NULL Name
    17 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    18 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    19 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    20 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    21 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    22 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    23 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default Value: %datetime

    24 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    25 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: %EDITTABLE5

    26 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    27 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
    GP=Global Payroll
    NA=Payroll for North America
    OT=Other
    PI=Payroll Interface

    Default Value: OPR_DEF_TBL_HR.PAY_SYSTEM_FLG

    28 HR_SRCH_PYGP_DESCR Character(30) VARCHAR2(30) NOT NULL Paygroup Description
    29 HR_SRCH_GPPY_DESCR Character(30) VARCHAR2(30) NOT NULL GP paygroup Description
    30 ABSENCE_SYSTEM_CD Character(3) VARCHAR2(3) NOT NULL What Absence System this Assignment is tied to.
    AM=Absence Management
    OT=Other

    Default Value: OT

    31 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    32 HR_SRCH_GP_XLAT Character(30) VARCHAR2(30) NOT NULL GP paysytem xlatlongname
    33 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    34 HR_SRCH_ABS_STM_CD Character(3) VARCHAR2(3) NOT NULL SES: Absence system code referenced in HR_SRCH_JOBDATA query
    35 HR_SRCH_ABS_XLAT Character(30) VARCHAR2(30) NOT NULL Abs paysytem xlatlongname
    36 HR_SRCH_CMP_DESCR Character(30) VARCHAR2(30) NOT NULL Company Descr
    37 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    38 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
    39 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
    40 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
    41 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
    42 ACTION Character(3) VARCHAR2(3) NOT NULL Action
    43 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
    44 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
    A=Active
    I=Inactive
    45 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Pay
    Q=Retired With Pay
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Pay
    V=Terminated Pension Pay Out
    W=Short Work Break
    X=Retired-Pension Administration
    46 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried
    47 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    48 SUPERVISOR_NAME Character(50) VARCHAR2(50) NOT NULL Supervisor Name
    49 REPORTS_TO_DESCR Character(50) VARCHAR2(50) NOT NULL Reports To
    50 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title
    51 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service
    52 MIL_RANK Character(5) VARCHAR2(5) NOT NULL Military Rank
    53 MIL_WORN_RANK Character(5) VARCHAR2(5) NOT NULL Worn Rank
    54 BUSINESS_DESCR Character(60) VARCHAR2(60) NOT NULL Business Description
    55 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status
    A=Administrative
    C=Computer Employee
    E=Executive
    H=Highly Compensated Employees
    M=Management
    N=Nonexempt
    O=Outside Salesperson
    P=Professional
    V=Nonexempt Alt Overtime
    X=No FLSA Required
    56 START_DATE Date(10) DATE Start Date for Gen Standing PO
    57 HR_RW_TYPE Character(1) VARCHAR2(1) NOT NULL Remote Worker Type(Fully remote/Hybrid)
    F=Fully Remote
    H=Hybrid
    58 HR_RW_REASON Character(60) VARCHAR2(60) NOT NULL Remote Worker Reason
    59 HR_RW_LOC_TYPE Character(1) VARCHAR2(1) NOT NULL Remote Worker Location Type
    H=Home
    O=Other
    W=Workplace
    60 HR_RW_LOCATION Character(30) VARCHAR2(30) NOT NULL Remote Work Location
    61 RW_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL Percentage
    62 RW_PERCENT_DESCR Character(30) VARCHAR2(30) NOT NULL Remote Work Percent
    63 RW_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Remote Worker Type
    64 RW_DAY1 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Monday
    A=Active
    I=Inactive
    65 RW_DAY2 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Monday
    A=Active
    I=Inactive
    66 RW_DAY3 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Wednesday
    A=Active
    I=Inactive
    67 RW_DAY4 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Thursday
    A=Active
    I=Inactive
    68 RW_DAY5 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Friday
    A=Active
    I=Inactive
    69 RW_DAY6 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Saturday
    A=Active
    I=Inactive
    70 RW_DAY7 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Sunday
    A=Active
    I=Inactive
    71 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
    A=Approved
    C=Cancelled
    D=Denied
    E=Error. Contact Administrator.
    F=Awaiting final approval
    I=In Approval Process
    M=Administrator is Processing
    N=Not Available
    P=Rework
    S=Submitted
    V=Data Saved
    72 GENDER_DESCR Character(100) VARCHAR2(100) NOT NULL Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
    73 HR_VET_DESCR Character(50) VARCHAR2(50) NOT NULL Veteran Description
    74 HR_RW_LTYP_DESCR Character(30) VARCHAR2(30) NOT NULL Remote Location Type
    75 HR_JF_DESCR Character(50) VARCHAR2(50) NOT NULL Job Family Description