BUSINESS_UNITSO_IDSO_LINEY/N Table Edit
RS_DF_RR_AVA_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.START_DT , A.END_DT , A.EST_DAYS , A.PERIOD_DAYS , PART_TIME_FLG FROM %Table(RS_DF_RR_VW) A WHERE A.EST_DAYS > 0 AND A.PERIOD_DAYS > 0 AND A.START_DT IS NOT NULL AND A.END_DT IS NOT NULL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SO_ID |
Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 3 | SO_LINE |
Number(3,0) | SMALLINT NOT NULL | Line Number |
| 4 | START_DT | Date(10) | DATE | Start Date |
| 5 | END_DT | Date(10) | DATE | End Date |
| 6 | EST_DAYS | Number(5,0) | INTEGER NOT NULL | Estimated number of days |
| 7 | PERIOD_DAYS | Number(5,0) | INTEGER NOT NULL | Number of Work Days |
| 8 | PART_TIME_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Part Time
Y/N Table Edit |