SPA_TRC_BRKA_VW

(SQL View)
 Index Back

Time Detail Hrly Adj Vw

Child table of SPA_TIM_DTL_DLY, used to breakout daily hours by TRC code. View used to display TRC breakdown from adjustment summary.

SELECT TIME_SHEET_ID ,TRC FROM PS_SPA_TM_HRLY_ADJ GROUP BY TIME_SHEET_ID , TRC

  • Parent record: SPA_TIM_DTL_DLY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
    2 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code