RF_W_TBL_CI_VW(SQL View) |
Index Back |
|---|---|
CI view for RF_WORKER_TBLThis view has the same structure as RF_WORKER_TBL. 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. This table will contain the employee ids of all employees who are also SRS resources. |
| SELECT A.PERSON_ID , A.AIRPORT , A.DESCR254 , A.SUN , A.MON , A.TUES , A.WED , A.THURS , A.FRI , A.SAT , A.TIME_FROM , A.TIME_TO , A.LONGITUDE , A.LONG_COMPASS , A.LATITUDE , A.LAT_COMPASS , A.DISTANCE , %subrec(FILE_ATTACH_SBR, A) , A.WORKER_SUMMARY , %subrec(RB_AUDIT_SBR, A) FROM PS_RF_WORKER_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 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 |
Y/N flag for providing the Start and End Time for Sunday
Y/N Table Edit Default Value: INSTALLATION.SUN |
| 5 | MON |
Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Monday
Y/N Table Edit Default Value: INSTALLATION.MON |
| 6 | TUES |
Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Tuesday.
Y/N Table Edit Default Value: INSTALLATION.TUES |
| 7 | WED |
Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Wednesday.
Y/N Table Edit Default Value: INSTALLATION.WED |
| 8 | THURS |
Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Thursday.
Y/N Table Edit Default Value: INSTALLATION.THURS |
| 9 | FRI |
Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Friday.
Y/N Table Edit Default Value: INSTALLATION.FRI |
| 10 | SAT |
Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Saturday.
Y/N Table Edit Default Value: INSTALLATION.SAT |
| 11 | TIME_FROM | Time(15) | TIMESTAMP |
From Time
Default Value: INSTALLATION.TIME_FROM |
| 12 | TIME_TO | Time(15) | TIMESTAMP |
To Time
Default Value: INSTALLATION.TIME_TO |
| 13 | LONGITUDE | Signed Number(32,20) | DECIMAL(30,20) NOT NULL | LONGITUDE |
| 14 | LONG_COMPASS | Character(1) | VARCHAR2(1) NOT NULL | Longitude Compass |
| 15 | LATITUDE | Signed Number(32,20) | DECIMAL(30,20) NOT NULL | LATITUDE |
| 16 | LAT_COMPASS | Character(1) | VARCHAR2(1) NOT NULL | Latitude Compass |
| 17 | DISTANCE | Number(5,0) | INTEGER NOT NULL | Distance Traveled |
| 18 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 19 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 20 | WORKER_SUMMARY | Long Character | CLOB | Worker summary/objective |
| 21 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 22 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 23 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 24 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 25 | 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. |
| 26 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |