TELEWORK_TBL(SQL Table) |
Index Back |
|---|---|
Telework Details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PER_ORG_ASGN.EMPLID Prompt Table: PERS_SRCH_GBL |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | START_DATE |
Date(10) | DATE NOT NULL | Start Date for Gen Standing PO |
| 4 | END_DATE | Date(10) | DATE | End Date |
| 5 | DAYS | Number(3,0) | SMALLINT NOT NULL | Days |
| 6 | AVERAGE_DAYS_MONTH | Number(2,0) | SMALLINT NOT NULL | Average Days Per Month |
| 7 | DISABILITY_AGMNTS | Character(1) | VARCHAR2(1) NOT NULL |
Disability Arrangements
N=Not Related to Disability P=Permanent Disability T=Temporary Disability Default Value: N |
| 8 | TELE_AGREEMENT | Character(1) | VARCHAR2(1) NOT NULL |
Telework Agreement
Y/N Table Edit |
| 9 | AGREEMENT_DATE | Date(10) | DATE | Agreement Date |
| 10 | SERVICE_COST | Character(2) | VARCHAR2(2) NOT NULL |
Service Cost
CS=Costs are shared NO=No associated equipments O=Other OP=Organization provides TP=Teleworker provides |
| 11 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |