BUSINESS_UNITTIME_SHEET_IDWORK_ORDER_IDLINE_NBRDefault Value: 1
Prompt Table: SPF_WO_DIST_VW
Prompt Table: SPF_ACTIVITY_VW
Prompt Table: SPA_TIM_ASGN_VW
ADJ=Adjusted
APR=Approved
DEN=Denied
OPN=Open
PND=Pending
SUB=Submitted
SPA_TM_INCDNT_V(SQL View) |
Index Back |
|---|---|
Timesheet incidents viewTimesheet incidents view |
| SELECT I.BUSINESS_UNIT , I.TIME_SHEET_ID , I.WORK_ORDER_ID , I.LINE_NBR , I.DISTRIB_LINE_NUM , I.ACTIVITY_ID , I.DATE_UNDER_RPT , I.ASSIGNMENT_ID , I.NUM_OF_INCIDENTS , I.TIME_LINE_STATUS FROM PS_SPA_TIM_INCIDNT I |
| # | 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 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 4 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 5 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL |
Distribution Line
Prompt Table: SPF_WO_DIST_VW |
| 6 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: SPF_ACTIVITY_VW |
| 7 | DATE_UNDER_RPT | Date(10) | DATE | Date Under Report |
| 8 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Work Assignment ID
Prompt Table: SPA_TIM_ASGN_VW |
| 9 | NUM_OF_INCIDENTS | Number(16,0) | DECIMAL(16) NOT NULL | Number of incidents |
| 10 | TIME_LINE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Time Line Status
ADJ=Adjusted APR=Approved DEN=Denied OPN=Open PND=Pending SUB=Submitted |