RS_WRK_SCHED_WS

(SQL Table)
Index Back

Worker schedule work rec

Work record table for workers' schedules.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SEQ_NUM2 Number(6,0) INTEGER NOT NULL Sequence Number
3 AMOUNT_TIME Signed Number(10,4) DECIMAL(8,4) NOT NULL Amount of Time
4 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Task Category
5 TASK_COLOR Number(2,0) SMALLINT NOT NULL Task colors.
6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
7 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
8 DATE_REPORT Date(10) DATE Report Date
9 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
10 RS_APPT_ID Character(15) VARCHAR2(15) NOT NULL Appointment Id