FO_RPD_PTIME_VW

(SQL View)
 Index Back

Punched Rapid Time - Staffing

A basic view of TL_RAPID_PTIME for use on Staffing component to allow configuring prompts on most enterable fields. The T&L component does not have prompt editing to speed up data entry.

SELECT ST_INSTANCE ,EMPLID ,EMPL_RCD ,DUR ,PUNCH_TIME ,PUNCH_DTTM ,TIMEZONE ,PUNCH_TYPE ,TASK_PROFILE_ID ,TASKGROUP ,COUNTRY ,STATE ,LOCALITY ,RULE_ELEMENT_1 ,RULE_ELEMENT_2 ,RULE_ELEMENT_3 ,RULE_ELEMENT_4 ,RULE_ELEMENT_5 ,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 ,TRC ,TL_QUANTITY ,CURRENCY_CD ,COMP_RATECD ,BILLABLE_IND ,OVERRIDE_RATE ,TL_COMMENTS FROM PS_TL_RAPID_PTIME

  • 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 PUNCH_TIME Time(15) TIMESTAMP NOT NULL punch time
    6 PUNCH_DTTM DateTime(26) TIMESTAMP Date and time when the punch occurred.
    7 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    8 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

    9 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID
    10 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

    Prompt Table: TL_TASKGRP_TBL

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_NAMES_TBL

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

    Prompt Table: LOCAL_TAX_TBL

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

    Prompt Table: TL_RULE_ELEMNT1

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

    Prompt Table: TL_RULE_ELEMNT2

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

    Prompt Table: TL_RULE_ELEMNT3

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

    Prompt Table: TL_RULE_ELEMNT4

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

    Prompt Table: TL_RULE_ELEMNT5

    19 OVERRIDE_RSN_CD Character(5) VARCHAR2(5) NOT NULL Override Reason Code

    Prompt Table: TL_OVRD_RSN_TBL

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

    Prompt Table: COMPANY_TBL

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

    Prompt Table: BUS_UNIT_TBL_HR

    22 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    23 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: TL_LOCATION_VW

    24 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    25 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: TL_DEPT_TBL_VW

    26 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    27 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: TL_JOBCODE_VW

    28 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    29 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product

    Prompt Table: TL_PRODUCT_TBL

    30 CUSTOMER Character(10) VARCHAR2(10) NOT NULL Customer
    31 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
    32 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL Project Costing Business Unit

    Prompt Table: BUS_UNIT_PC_VW

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

    Prompt Table: PROJ_TEAM_TL_VW

    35 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity Set ID
    36 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: FO_ACTIVITY_VW

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

    Prompt Table: TL_PROJ_RTYPE_V

    38 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource Set ID
    39 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Category

    Prompt Table: %RECNAME_EDIT

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

    Prompt Table: %RECNAME_EDIT2

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

    Prompt Table: TL_TASK

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

    Prompt Table: TL_USER_FIELD_1

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

    Prompt Table: TL_USER_FIELD_2

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

    Prompt Table: TL_USER_FIELD_3

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

    Prompt Table: TL_USER_FIELD_4

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

    Prompt Table: TL_USER_FIELD_5

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

    Prompt Table: TL_TR_TRC_VW

    48 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,

    Default Value: 0

    49 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    50 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
    51 BILLABLE_IND Character(1) VARCHAR2(1) NOT NULL Billable Indicator
    N=No
    Y=Yes

    Default Value: Y

    52 OVERRIDE_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Override Rate.
    53 TL_COMMENTS Character(254) VARCHAR2(254) NOT NULL Comments