FO_RPD_TIME_VW

(SQL View)
 Index Back

Elapsed Rapid Time - Staffing

A basic view of TL_RAPID_TIME to allow configuring prompt editing on most of the enterable fields. There is no editing on the T&L component to allow for speedy data entry.

SELECT ST_INSTANCE ,EMPLID ,EMPL_RCD ,DUR ,SEQNUM ,PUNCH_TIME ,PUNCH_DTTM ,TIMEZONE ,PUNCH_TYPE ,TRC ,TL_QUANTITY ,CURRENCY_CD ,TASK_PROFILE_ID ,TASKGROUP ,COUNTRY ,STATE ,LOCALITY ,COMP_RATECD ,BILLABLE_IND ,RULE_ELEMENT_1 ,RULE_ELEMENT_2 ,RULE_ELEMENT_3 ,RULE_ELEMENT_4 ,RULE_ELEMENT_5 ,OVERRIDE_RATE ,SHIFT ,OVERRIDE_RSN_CD ,COMPANY ,BUSINESS_UNIT ,SETID_LOCATION ,LOCATION ,SETID_DEPT ,DEPTID ,SETID_JOBCODE ,JOBCODE ,POSITION_NBR ,PRODUCT ,CUSTOMER ,ACCT_CD ,BUSINESS_UNIT_PC ,BUSINESS_UNIT_PF ,PROJECT_ID ,SETID_ACTIVITY ,ACTIVITY_ID ,RESOURCE_TYPE ,SETID_RESOURCE ,RESOURCE_CATEGORY ,RESOURCE_SUB_CAT ,TASK ,USER_FIELD_1 ,USER_FIELD_2 ,USER_FIELD_3 ,USER_FIELD_4 ,USER_FIELD_5 ,TL_COMMENTS FROM PS_TL_RAPID_TIME

  • Parent record: TL_RAPID_HEADER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ST_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Submit Time Instance
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: FO_TL_EMPLID_VW

    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    4 DUR Date(10) DATE NOT NULL Date Under Report associates time being reported, scheduled or paid, to a specific date.
    5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

    6 PUNCH_TIME Time(15) TIMESTAMP punch time
    7 PUNCH_DTTM DateTime(26) TIMESTAMP Date and time when the punch occurred.
    8 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    9 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_PUNCH4_VW

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

    Prompt Table: TL_TR_TRC_VW

    11 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    13 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID
    14 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

    Prompt Table: TL_TASKGRP_TBL

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_NAMES_TBL

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

    Prompt Table: LOCAL_TAX_TBL

    18 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
    19 BILLABLE_IND Character(1) VARCHAR2(1) NOT NULL Billable Indicator
    N=No
    Y=Yes

    Default Value: Y

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

    Prompt Table: TL_RULE_ELEMNT1

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

    Prompt Table: TL_RULE_ELEMNT2

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

    Prompt Table: TL_RULE_ELEMNT3

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

    Prompt Table: TL_RULE_ELEMNT4

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

    Prompt Table: TL_RULE_ELEMNT5

    25 OVERRIDE_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Override Rate.
    26 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=Day
    2=Evening
    3=Night
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating
    27 OVERRIDE_RSN_CD Character(5) VARCHAR2(5) NOT NULL Override Reason Code

    Prompt Table: TL_OVRD_RSN_TBL

    28 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: BUS_UNIT_TBL_HR

    30 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    31 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: TL_LOCATION_VW

    32 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    33 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: TL_DEPT_TBL_VW

    34 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    35 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: TL_JOBCODE_VW

    36 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    37 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product

    Prompt Table: TL_PRODUCT_TBL

    38 CUSTOMER Character(10) VARCHAR2(10) NOT NULL Customer
    39 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
    40 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL Project Costing Business Unit

    Prompt Table: BUS_UNIT_PC_VW

    41 BUSINESS_UNIT_PF Character(5) VARCHAR2(5) NOT NULL Perf Meas Business Unit
    42 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant

    Prompt Table: PROJ_TEAM_TL_VW

    43 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity Set ID
    44 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: FO_ACTIVITY_VW

    45 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Type

    Prompt Table: TL_PROJ_RTYPE_V

    46 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource Set ID
    47 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Category

    Prompt Table: %RECNAME_EDIT

    48 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Sub Category

    Prompt Table: %RECNAME_EDIT2

    49 TASK Character(5) VARCHAR2(5) NOT NULL Task

    Prompt Table: TL_TASK

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

    Prompt Table: TL_USER_FIELD_1

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

    Prompt Table: TL_USER_FIELD_2

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

    Prompt Table: TL_USER_FIELD_3

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

    Prompt Table: TL_USER_FIELD_4

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

    Prompt Table: TL_USER_FIELD_5

    55 TL_COMMENTS Character(254) VARCHAR2(254) NOT NULL Comments