SCH_SHIFT_DTL

(SQL Table)
 Index Back

Schedule Shift Detail

The Schedule Shift Detail table identifies shift detail at the punch level for a shift. A shift may contain any number of punches and cover any time span up to ten days; the ten day limitation is an arbitrary one imposed by the size of the DUR_OFFSET field which keeps track of what day a punch falls on in relation to the start day of the shift. The Schedule Configuration Indicators have special meaning for Global Payroll processing, but may be used by other applications as long as they are maintained correctly for Global Payroll's use. For Release 8.0 and beyond, the Scheduling feature is a shared feature that will be utilized by multiple products including Time & Labor and Global Payroll.

  • 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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    5 PUNCH_TIME Time(15) TIMESTAMP Punch Time
    6 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    7 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
    0=Elapsed
    1=In
    2=Out
    3=Meal
    4=Break
    5=Transfer

    Prompt Table: SCH_PUNCH_VW

    8 STRT_STOP_DIFF Number(5,2) DECIMAL(4,2) NOT NULL Start Stop Time Duration
    9 DUR_OFFSET Signed Number(2,0) DECIMAL(1) NOT NULL Date Under Report Offset identifies the number of days following the start day of a shift to assign a specific punch to. If the punch lands on the same day as the start of the shift, the offset is zero. If it lands on the following day, then the offset is one and so on.
    10 PUNCH_END_TIME Time(15) TIMESTAMP Punch End Time
    11 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

    12 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

    13 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

    14 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

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

    Prompt Table: TL_HRS_TRC_VW

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

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

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

    Prompt Table: LOCAL_TAX_TBL

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

    Prompt Table: COMP_RT_REG_VW

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: TL_OVRD_RSN_TBL

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

    Prompt Table: TL_RULE_ELEMNT1

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

    Prompt Table: TL_RULE_ELEMNT2

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

    Prompt Table: TL_RULE_ELEMNT3

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

    Prompt Table: TL_RULE_ELEMNT4

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

    Prompt Table: TL_RULE_ELEMNT5

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

    Prompt Table: TL_TSKGRP_PRF_V

    30 TL_COMMENTS Character(254) VARCHAR2(254) NOT NULL Comments
    31 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: TL_BUS_UNIT_VW

    33 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
    34 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: TL_LOCATION_VW

    35 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
    36 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: TL_DEPT_TBL_VW

    37 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
    38 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: TL_JOBCODE_VW

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

    Prompt Table: POSITION_DATA

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

    Prompt Table: TL_PRODUCT_TBL

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

    Prompt Table: TL_CUSTOMER

    42 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
    43 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    44 BUSINESS_UNIT_PF Character(5) VARCHAR2(5) NOT NULL Perf Meas Business Unit

    Prompt Table: BUS_UNIT_TBL_PF

    45 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
    46 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity SetID
    47 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    48 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Resource Type

    Prompt Table: TL_PROJ_RTYPE_V

    49 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource SetID
    50 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Resource Category
    51 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Resource Sub Category
    52 TASK Character(5) VARCHAR2(5) NOT NULL Task

    Prompt Table: TL_TASK

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

    Prompt Table: TL_USER_FIELD_1

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

    Prompt Table: TL_USER_FIELD_2

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

    Prompt Table: TL_USER_FIELD_3

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

    Prompt Table: TL_USER_FIELD_4

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

    Prompt Table: TL_USER_FIELD_5

    58 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    59 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.