RF_WORKER_TBL(SQL Table) |
Index Back |
|---|---|
SRS Worker TableThis table will contain the employee ids of all employees who are also SRS resources. |
| # | 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 |