HR_RWORK_TBL

(SQL Table)
 Index Back

Remote Worker Details

Stores the remote worker details

  • Related Language Record: HR_RWORK_LNG

  • Parent Record Of HR_RW_ACK_DET HR_RW_SS_ATT

    • # 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

    Default Value: 0

    3 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
    4 END_DATE Date(10) DATE End Date
    5 DAYS Number(3,0) SMALLINT NOT NULL Days
    6 HR_RW_TYPE Character(1) VARCHAR2(1) NOT NULL Remote Worker Type(Fully remote/Hybrid)
    F=Fully Remote
    H=Hybrid
    7 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    8 HR_RW_REASON Character(60) VARCHAR2(60) NOT NULL Remote Worker Reason

    Prompt Table: HR_RW_REASON

    9 HR_RW_LOC_TYPE Character(1) VARCHAR2(1) NOT NULL Remote Worker Location Type
    H=Home
    O=Other
    W=Workplace
    10 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    11 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: HR_RW_LOC_VW

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

    Prompt Table: COUNTRY_TBL

    13 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    14 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    15 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    16 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    17 CITY Character(30) VARCHAR2(30) NOT NULL City
    18 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    19 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    20 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    21 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    22 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    23 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    24 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    25 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    26 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    27 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    28 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    29 RW_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL Percentage
    30 HR_RW_TRACK_DAYS Character(1) VARCHAR2(1) NOT NULL Remote Worker Track Days
    M=Average Days Per Month
    S=Specific Days Per Week
    W=Average Days Per Week
    31 RW_DAY1 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Monday
    A=Active
    I=Inactive

    Default Value: I

    32 RW_DAY2 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Monday
    A=Active
    I=Inactive

    Default Value: I

    33 RW_DAY3 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Wednesday
    A=Active
    I=Inactive

    Default Value: I

    34 RW_DAY4 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Thursday
    A=Active
    I=Inactive

    Default Value: I

    35 RW_DAY5 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Friday
    A=Active
    I=Inactive

    Default Value: I

    36 RW_DAY6 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Saturday
    A=Active
    I=Inactive

    Default Value: I

    37 RW_DAY7 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Sunday
    A=Active
    I=Inactive

    Default Value: I

    38 HR_RW_AVG_MONTH Number(4,1) DECIMAL(3,1) NOT NULL Average Days Per Month
    39 HR_RW_AVG_WEEK Number(4,1) DECIMAL(3,1) NOT NULL Average Days Per Month
    40 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    41 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    42 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    43 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    44 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    45 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    46 SS_STAT_INDICATOR Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    A=Approved
    B=CI failed - Errors & Warnings
    C=Cancelled
    D=Denied
    E=Errors Encountered
    I=In Approval Process
    M=Administrator Action Required
    S=Success
    W=Warnings Encountered

    Default Value: I

    47 SS_WARNING_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

    Y/N Table Edit

    Default Value: N

    48 SS_FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

    Y/N Table Edit

    Default Value: N

    49 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
    50 RW_SS_STATUS Character(1) VARCHAR2(1) NOT NULL Health and Safety self-service status
    A=Approved
    D=Denied
    I=Draft
    M=Pushed Back
    P=Pending Approval
    S=Submitted
    51 AGC_LIST_ID Character(31) VARCHAR2(31) NOT NULL Activity Guide Composer List Id
    52 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    53 HR_RW_DATA_SOURCE Character(1) VARCHAR2(1) NOT NULL Remote worker Data Source
    1=Employee Self Service
    2=Manager Self Service
    54 LAST_UPDATE_DTTM 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.
    55 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name