RS_WORKER_TBL

(SQL Table)
 Index Back

SRS Worker Table

This table will contain the employee ids of all employees who are also SRS resources. SUJ--The Dynamic prompt at EMPLID is to get employees who are not yet RS or WM or STF resources depending on menu the user navigates.

  • Parent Record Of RS_WRKR_EFFDT

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

    Prompt Table: %EDITTABLE

    2 AIRPORT Character(30) VARCHAR2(30) NOT NULL This field will represent the home airport for the employee.
    3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    4 SUN Character(1) VARCHAR2(1) NOT NULL Sunday

    Y/N Table Edit

    Default Value: INSTALLATION_RS.SUN

    5 MON Character(1) VARCHAR2(1) NOT NULL Monday

    Y/N Table Edit

    Default Value: INSTALLATION_RS.MON

    6 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday

    Y/N Table Edit

    Default Value: INSTALLATION_RS.TUES

    7 WED Character(1) VARCHAR2(1) NOT NULL Wednesday

    Y/N Table Edit

    Default Value: INSTALLATION_RS.WED

    8 THURS Character(1) VARCHAR2(1) NOT NULL Thursday

    Y/N Table Edit

    Default Value: INSTALLATION_RS.THURS

    9 FRI Character(1) VARCHAR2(1) NOT NULL Friday

    Y/N Table Edit

    Default Value: INSTALLATION_RS.FRI

    10 SAT Character(1) VARCHAR2(1) NOT NULL Saturday

    Y/N Table Edit

    Default Value: INSTALLATION_RS.SAT

    11 STD_DAYS Number(4,2) DECIMAL(3,2) NOT NULL Standard Number of Days/Week

    Default Value: INSTALLATION_RS.STD_DAYS

    12 LONGITUDE Signed Number(12,7) DECIMAL(10,7) NOT NULL Longitude
    13 LONG_COMPASS Character(1) VARCHAR2(1) NOT NULL Longitude Compass
    14 LATITUDE Signed Number(12,7) DECIMAL(10,7) NOT NULL Latitude
    15 LAT_COMPASS Character(1) VARCHAR2(1) NOT NULL Latitude Compass
    16 DISTANCE Number(8,2) DECIMAL(7,2) NOT NULL Distance Traveled
    17 DISTANCE_TYPE Character(1) VARCHAR2(1) NOT NULL Distance Type
    3=Metres
    K=Kilometers
    M=Miles

    Default Value: M

    18 WORKER_SUMMARY Long Character CLOB Worker summary/objective
    19 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: PROJ_ROLE
    Set Control Field: BUSINESS_UNIT

    20 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

    Prompt Table: RS_REGION

    21 SELECT_CMP Character(1) VARCHAR2(1) NOT NULL Include Competency for Search

    Y/N Table Edit

    Default Value: Y

    22 SELECT_DEG Character(1) VARCHAR2(1) NOT NULL Include Education for Search

    Y/N Table Edit

    Default Value: Y

    23 SELECT_LIC Character(1) VARCHAR2(1) NOT NULL Include Licenses for Search

    Y/N Table Edit

    Default Value: Y

    24 SELECT_LNG Character(1) VARCHAR2(1) NOT NULL Include Languages for Search

    Y/N Table Edit

    Default Value: Y

    25 SELECT_MEM Character(1) VARCHAR2(1) NOT NULL Include Memberships for Search

    Y/N Table Edit

    Default Value: Y