SCH_SHIFT_WRK

(SQL Table)
 Index Back

Schedule Shift Detail Work

The Schedule Shift Detail Work table identifies is used on the Shift definition page for entering Shift details at the punch level for a shift. This is a work table used by the Shift definition page to allow for multiple Punch Times displayed across the page. The actual Shift details will be moved to SCH_SHIFT_DTL table.

  • Parent record: SCH_SHIFT_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SET_VLD_TL_01

    2 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 PUNCH_TIME_1 Time(15) TIMESTAMP Punch Time 1
    5 PUNCH_TIME_2 Time(15) TIMESTAMP Punch Time 2
    6 PUNCH_TIME_3 Time(15) TIMESTAMP Punch Time 3
    7 PUNCH_TIME_4 Time(15) TIMESTAMP Punch Time 4
    8 PUNCH_TIME_5 Time(15) TIMESTAMP Punch Time 5
    9 PUNCH_TIME_6 Time(15) TIMESTAMP Punch Time 6
    10 PUNCH_TIME_7 Time(15) TIMESTAMP Punch Time 7
    11 PUNCH_TIME_8 Time(15) TIMESTAMP Punch Time 8
    12 PUNCH_TIME_9 Time(15) TIMESTAMP Punch Time 9
    13 PUNCH_TIME_10 Time(15) TIMESTAMP Punch Time 10
    14 STRT_STOP_DIFF Number(5,2) DECIMAL(4,2) NOT NULL Start Stop Time Duration
    15 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    16 SCH_CONFIG_IND1 Character(1) VARCHAR2(1) NOT NULL Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.

    Y/N Table Edit

    Default Value: N

    17 SCH_CONFIG_IND2 Character(1) VARCHAR2(1) NOT NULL Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.

    Y/N Table Edit

    Default Value: N

    18 SCH_CONFIG_IND3 Character(1) VARCHAR2(1) NOT NULL Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.

    Y/N Table Edit

    Default Value: N

    19 SCH_CONFIG_IND4 Character(1) VARCHAR2(1) NOT NULL Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.

    Y/N Table Edit

    Default Value: N

    20 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor

    Prompt Table: TL_HRS_TRC_VW

    21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    22 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    23 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    24 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

    Prompt Table: LOCAL_TAX_TBL

    25 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

    Prompt Table: COMP_RT_REG_VW

    26 BILLABLE_IND Character(1) VARCHAR2(1) NOT NULL Billable Indicator
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    27 OVERRIDE_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Override Rate.
    28 OVERRIDE_RSN_CD Character(5) VARCHAR2(5) NOT NULL Override Reason Code

    Prompt Table: TL_OVRD_RSN_TBL

    29 RULE_ELEMENT_1 Character(10) VARCHAR2(10) NOT NULL Rule Element 1

    Prompt Table: TL_RULE_ELEMNT1

    30 RULE_ELEMENT_2 Character(10) VARCHAR2(10) NOT NULL Rule Element 2

    Prompt Table: TL_RULE_ELEMNT2

    31 RULE_ELEMENT_3 Character(10) VARCHAR2(10) NOT NULL Rule Element 3

    Prompt Table: TL_RULE_ELEMNT3

    32 RULE_ELEMENT_4 Character(10) VARCHAR2(10) NOT NULL Rule Element 4

    Prompt Table: TL_RULE_ELEMNT4

    33 RULE_ELEMENT_5 Character(10) VARCHAR2(10) NOT NULL Rule Element 5

    Prompt Table: TL_RULE_ELEMNT5

    34 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID

    Prompt Table: TL_TSKGRP_PRF_V

    35 TL_COMMENTS Character(254) VARCHAR2(254) NOT NULL Comments
    36 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    37 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: TL_BUS_UNIT_VW

    38 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
    39 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: TL_LOCATION_VW

    40 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
    41 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: TL_DEPT_TBL_VW

    42 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
    43 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: TL_JOBCODE_VW

    44 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    45 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product

    Prompt Table: TL_PRODUCT_TBL

    46 CUSTOMER Character(10) VARCHAR2(10) NOT NULL Customer

    Prompt Table: TL_CUSTOMER

    47 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
    48 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    49 BUSINESS_UNIT_PF Character(5) VARCHAR2(5) NOT NULL Perf Meas Business Unit

    Prompt Table: BUS_UNIT_TBL_PF

    50 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
    51 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity SetID
    52 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    53 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Resource Type

    Prompt Table: TL_PROJ_RTYPE_V

    54 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource SetID
    55 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Resource Category
    56 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Resource Sub Category
    57 TASK Character(5) VARCHAR2(5) NOT NULL Task

    Prompt Table: TL_TASK

    58 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1

    Prompt Table: TL_USER_FIELD_1

    59 USER_FIELD_2 Character(10) VARCHAR2(10) NOT NULL User Field 2

    Prompt Table: TL_USER_FIELD_2

    60 USER_FIELD_3 Character(15) VARCHAR2(15) NOT NULL User Field 3

    Prompt Table: TL_USER_FIELD_3

    61 USER_FIELD_4 Character(20) VARCHAR2(20) NOT NULL User Field 4

    Prompt Table: TL_USER_FIELD_4

    62 USER_FIELD_5 Character(20) VARCHAR2(20) NOT NULL User Field 5

    Prompt Table: TL_USER_FIELD_5