SPA_TIM_ADD_VW (SQL View)	Index Back
Time Report Add View Time Report Add View

SPA_TIM_ADD_VW

(SQL View)

Time Report Add View

SELECT DISTINCT a.person_id , a.period_end_dt , a.business_unit , c.work_order_id , a.time_sheet_id FROM ps_spa_time_hdr a , ps_spb_service_prv b , PS_SPA_TIME_DTL c WHERE a.person_id = b.person_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: %EDITTABLE

2 PERIOD_END_DT Date(10) DATE NOT NULL Represents the date termination point for a given time set utilized in cash worksheet processing.

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SPB_WO_BU_SP_VW

4 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
Prompt Table: SPA_TE_WO_VW

5 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: %EDITTABLE
2	PERIOD_END_DT	Date(10)	DATE NOT NULL	Represents the date termination point for a given time set utilized in cash worksheet processing.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SPB_WO_BU_SP_VW
4	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID Prompt Table: SPA_TE_WO_VW
5	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)