BUSINESS_UNITTIME_SHEET_IDRF_TIME_LINE_VW(SQL View) |
Index Back |
|---|---|
Header and Line ViewUsed to retrieve time log data for a given service order line. |
| SELECT A.BUSINESS_UNIT , A.TIME_SHEET_ID , A.SO_ID , A.SO_LINE , B.LINE_NBR , B.PERSON_ID , B.START_DT , B.START_TIME , B.END_DT , B.END_TIME , B.DTL_TOTAL , B.HOURS_REM FROM PS_RF_TIME A , PS_RF_TIME_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.TIME_SHEET_ID = B.TIME_SHEET_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TIME_SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 3 | SO_ID | Character(10) | VARCHAR2(10) NOT NULL | Service Order ID |
| 4 | SO_LINE | Number(3,0) | SMALLINT NOT NULL | Stores the Service Order line number. |
| 5 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | This field represents the integer Order Line Number. |
| 6 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 7 | START_DT | Date(10) | DATE | Start date field to store start date value. |
| 8 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 9 | END_DT | Date(10) | DATE | This field stores the end date values. |
| 10 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 11 | DTL_TOTAL | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Total |
| 12 | HOURS_REM | Number(6,2) | DECIMAL(5,2) NOT NULL | Remaining Hours not covered by Prepaid. |