WM_SRCH_LBR

(SQL Table)
Index Back

Manual Labor Search

Manual Labor Search

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification
4 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
5 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID
6 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
7 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
8 RS_CALENDAR Character(1) VARCHAR2(1) NOT NULL Calendar field.
9 FIT_SCORE_AVA Signed Number(7,4) DECIMAL(5,4) NOT NULL Availability Fit Score
10 FIT_DISPLAY_AVA Character(15) VARCHAR2(15) NOT NULL Display availability fitness score.