RF_W_TIME2CI_VW

(SQL View)
 Index Back

CI View for RF_WORKER_TIME

This view has the same structure as RF_WORKER_TIME. This view does not contain any PeopleCode and is used in Component Interface (CI) components only. Whenever the structure of the underlying record changes, this view must be modified accordingly. The start/end time for each day of the week. These determine the hours the worker is available to be assigned to service orders or cases.

SELECT A.PERSON_ID , 2 , A.START_TIME , 2 , A.START_TIME , A.END_TIME , %subrec(RB_AUDIT_SBR, A) FROM PS_RF_WORKER_TIME A WHERE A.DAYOFWEEK = 2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 DAYOFWEEK Number(1,0) SMALLINT NOT NULL Day of Week

Default Value: 2

3 START_TIME Time(15) TIMESTAMP Start of Shift
4 DAYOFWEEK1 Number(1,0) SMALLINT NOT NULL Day of Week
5 START_TIME1 Time(15) TIMESTAMP Start of Shift
6 END_TIME Time(15) TIMESTAMP End of Shift
7 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
8 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
9 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
10 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
11 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
12 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time