SCH_DEFN_SHFT

(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_DEFN_DTL

    • # 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 SCH_ADHOC_IND Character(1) VARCHAR2(1) NOT NULL This field is used on Schedule Definitions to indicate if a Schedule is Ad Hoc (i.e. belonging to a specific employee) or Common (used by many employees)
    1=Common Schedule
    2=Ad Hoc Primary Schedule
    3=Ad Hoc Alternate Schedule
    3 SCHEDULE_ID Character(16) VARCHAR2(16) NOT NULL The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition).
    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 DAYNUM Number(3,0) SMALLINT NOT NULL Day Number
    6 SHIFTNUM Number(2,0) SMALLINT NOT NULL Shift Sequence Number
    7 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    8 PUNCH_TIME Time(15) TIMESTAMP Punch Time
    9 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    10 PUNCH_END_TIME Time(15) TIMESTAMP Punch End Time
    11 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

    12 STRT_STOP_DIFF Number(5,2) DECIMAL(4,2) NOT NULL Start Stop Time Duration
    13 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.
    14 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

    15 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

    16 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

    17 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

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

    Prompt Table: TL_HRS_TRC_VW

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

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

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

    Prompt Table: LOCAL_TAX_TBL

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

    Prompt Table: COMP_RT_REG_VW

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: TL_OVRD_RSN_TBL

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

    Prompt Table: TL_RULE_ELEMNT1

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

    Prompt Table: TL_RULE_ELEMNT2

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

    Prompt Table: TL_RULE_ELEMNT3

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

    Prompt Table: TL_RULE_ELEMNT4

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

    Prompt Table: TL_RULE_ELEMNT5

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

    Prompt Table: TL_TSKGRP_PRF_V

    33 TL_COMMENTS Character(254) VARCHAR2(254) NOT NULL Comments
    34 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: TL_BUS_UNIT_VW

    36 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
    37 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: TL_LOCATION_VW

    38 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
    39 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: TL_DEPT_TBL_VW

    40 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
    41 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: TL_JOBCODE_VW

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

    Prompt Table: POSITION_DATA

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

    Prompt Table: TL_PRODUCT_TBL

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

    Prompt Table: TL_CUSTOMER

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

    Prompt Table: BUS_UNIT_TBL_PF

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

    Prompt Table: TL_PROJ_RTYPE_V

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

    Prompt Table: TL_TASK

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

    Prompt Table: TL_USER_FIELD_1

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

    Prompt Table: TL_USER_FIELD_2

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

    Prompt Table: TL_USER_FIELD_3

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

    Prompt Table: TL_USER_FIELD_4

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

    Prompt Table: TL_USER_FIELD_5