SPA_TIME_TMPL

(SQL Table)
 Index Back

Templates

Stores templates to be used on Time Sheets and Progress Logs. Date Initials Reference # Description 01708 Prag 1715742003 Timesheets can be created now with the option of manually selecting the time reporting codes differently across the lines.

  • Related Language Record: SPA_TM_TMPL_LNG

  • Parent Record Of SPA_TM_TMPL_TRC SPB_TMTMPL_SHFT

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 TE_TEMPLATE_ID Character(8) VARCHAR2(8) NOT NULL Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash expense sheets.
    3 SPA_TEMPLATE_TYPE Character(1) VARCHAR2(1) NOT NULL Used to identify what document/transaction is associated with a particular template. This is a translate table field whose value is always Service Time/Expense
    D=Deliverables Template
    T=Resource Template

    Default Value: T

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 SPA_ALLOW_24 Character(1) VARCHAR2(1) NOT NULL Allow for more than 24 hours
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    9 SPA_USE_ISSUES Character(1) VARCHAR2(1) NOT NULL Use Comments
    N=No
    Y=Yes

    Default Value: Y

    10 SPA_USE_RATINGS Character(1) VARCHAR2(1) NOT NULL Use Ratings
    N=No
    Y=Yes

    Default Value: N

    11 SPA_FORMAT Character(1) VARCHAR2(1) NOT NULL Format
    D=Daily

    Default Value: D

    12 SPA_TIMERPT_PERIOD Character(1) VARCHAR2(1) NOT NULL Time Report Period
    B=Bi-Weekly
    D=Daily
    M=Monthly
    S=Semi-Monthly
    W=Weekly

    Default Value: W

    13 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

    Prompt Table: %EDITTABLE

    14 CALENDAR_WK Character(2) VARCHAR2(2) NOT NULL Weekly Calendar

    Prompt Table: SPB_CAL_WK_VW

    15 HOLIDAY_LIST_ID Character(10) VARCHAR2(10) NOT NULL This is used to identify what holiday calendar to use. This is the access field for all financials groups.

    Prompt Table: BUS_CAL_HOL_DFN

    16 END_DAY_OF_PERIOD Character(1) VARCHAR2(1) NOT NULL Ending Day of Period
    1=Sunday
    2=Monday
    3=Tuesday
    4=Wednesday
    5=Thursday
    6=Friday
    7=Saturday

    Default Value: 6

    17 USE_OT Character(1) VARCHAR2(1) NOT NULL Use Overtime

    Y/N Table Edit

    Default Value: N

    18 SPA_TIME_RULE_ID Character(10) VARCHAR2(10) NOT NULL Time Reporting Rule ID

    Prompt Table: SPA_TRULE_DFN

    19 USE_24HR_CLOCK Character(1) VARCHAR2(1) NOT NULL Time entry will use start and stop times if this flag is set to yes.

    Y/N Table Edit

    Default Value: N

    20 CALC_OT Character(1) VARCHAR2(1) NOT NULL Method used to calculate overtime - by period or weekly.
    D=Day
    P=Time Period

    Default Value: D

    21 WKEND_TRC Character(5) VARCHAR2(5) NOT NULL Default for Weekends

    Prompt Table: SPA_OT_TRC_VW

    22 TIME_RND_OPTION Character(1) VARCHAR2(1) NOT NULL Rounding options when the 24 hour clock is being used in time entry.
    D=Down
    N=None
    U=Up

    Default Value: N

    23 TIME_RND_INT Character(2) VARCHAR2(2) NOT NULL Rounding precision used with the 24-hour clock in time entry.
    10=Ten
    12=Twelve
    15=Fifteen
    20=Twenty
    30=Thirty
    6=Six
    24 TIME_BREAK_DUR Number(3,0) SMALLINT NOT NULL Break Duration (Min)

    Default Value: 0

    25 SPA_SHOW_BREAK Character(1) VARCHAR2(1) NOT NULL Show Break Duration

    Y/N Table Edit

    Default Value: N

    26 DERIVE_SHIFT_TOD Character(1) VARCHAR2(1) NOT NULL Derive Shift from Time of Day

    Default Value: N

    27 SP_BILL_METHOD Character(1) VARCHAR2(1) NOT NULL Used in Service Based Workorders to identify the billing method.
    F=Fixed Amount
    M=Milestone
    P=Percentage
    R=Rate Based

    Default Value: M

    28 SP_TIME_REPORT_OPT Character(1) VARCHAR2(1) NOT NULL Time Reporting Option
    A=Actual Allocation
    D=Default from Business Unit
    P=Percent Allocation

    Default Value: P

    29 SPA_START_TIME Time(15) TIMESTAMP Start time used in time entry with the 24-hour clock option.
    30 SPA_STOP_TIME Time(15) TIMESTAMP Start time used in time entry with the 24-hour clock option.
    31 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Y/N Table Edit

    32 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

    Y/N Table Edit

    33 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Y/N Table Edit

    34 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
    35 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
    36 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
    37 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
    38 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
    39 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
    40 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
    41 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    42 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
    43 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
    44 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
    45 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
    46 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    47 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    48 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    49 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
    50 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
    51 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
    52 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
    53 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    54 MANUAL_TRC_ENTRY Character(1) VARCHAR2(1) NOT NULL Date Initials Reference # Description 101708 Prag 1715742003 Timesheets can be created now with the option of manually selecting the time reporting codes differently across the lines.
    N=Off
    Y=On

    Y/N Table Edit

    Default Value: N