RF_WORKER_TBLVW(SQL View) |
Index Back |
|---|---|
SRS Worker TableThis table will contain the employee ids of all employees who are also SRS resources. |
| SELECT A.BO_ID , B.PERSON_ID , B.AIRPORT , B.DESCR254 , B.SUN , B.MON , B.TUES , B.WED , B.THURS , B.FRI , B.SAT , B.TIME_FROM , B.TIME_TO , B.LONGITUDE , B.LONG_COMPASS , B.LATITUDE , B.LAT_COMPASS , B.DISTANCE ,%subrec(FILE_ATTACH_SBR, B) , B.WORKER_SUMMARY ,%subrec(RB_AUDIT_SBR, B) FROM PS_RD_PERSON A , PS_RF_WORKER_TBL B WHERE A.PERSON_ID = B.PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 3 | AIRPORT | Character(30) | VARCHAR2(30) NOT NULL | This field will represent the home airport for the employee. |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 5 | 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 |
| 6 | 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 |
| 7 | 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 |
| 8 | 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 |
| 9 | 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 |
| 10 | 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 |
| 11 | 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 |
| 12 | TIME_FROM | Time(15) | TIMESTAMP |
From Time
Default Value: INSTALLATION.TIME_FROM |
| 13 | TIME_TO | Time(15) | TIMESTAMP |
To Time
Default Value: INSTALLATION.TIME_TO |
| 14 | LONGITUDE | Signed Number(32,20) | DECIMAL(30,20) NOT NULL | LONGITUDE |
| 15 | LONG_COMPASS | Character(1) | VARCHAR2(1) NOT NULL | Longitude Compass |
| 16 | LATITUDE | Signed Number(32,20) | DECIMAL(30,20) NOT NULL | LATITUDE |
| 17 | LAT_COMPASS | Character(1) | VARCHAR2(1) NOT NULL | Latitude Compass |
| 18 | DISTANCE | Number(5,0) | INTEGER NOT NULL | Distance Traveled |
| 19 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 20 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 21 | WORKER_SUMMARY | Long Character | CLOB | Worker summary/objective |
| 22 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 23 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 24 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 25 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 26 | 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. |
| 27 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |