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 Session Number
    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 Rcd Nbr
    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
    11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    12 STATE Character(6) VARCHAR2(6) NOT NULL State
    13 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
    14 RULE_ELEMENT_1 Character(10) VARCHAR2(10) NOT NULL Rule Element 1
    15 RULE_ELEMENT_2 Character(10) VARCHAR2(10) NOT NULL Rule Element 2
    16 RULE_ELEMENT_3 Character(10) VARCHAR2(10) NOT NULL Rule Element 3
    17 RULE_ELEMENT_4 Character(10) VARCHAR2(10) NOT NULL Rule Element 4
    18 RULE_ELEMENT_5 Character(10) VARCHAR2(10) NOT NULL Rule Element 5
    19 OVERRIDE_RSN_CD Character(5) VARCHAR2(5) NOT NULL Override Reason Code
    20 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    21 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    22 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
    23 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    24 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
    25 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    26 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
    27 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    28 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    29 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
    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 PC Business Unit
    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
    35 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity SetID
    36 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    37 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Resource Type
    38 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource SetID
    39 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Resource Category
    40 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Resource Sub Category
    41 TASK Character(5) VARCHAR2(5) NOT NULL Task
    42 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1
    43 USER_FIELD_2 Character(10) VARCHAR2(10) NOT NULL User Field 2
    44 USER_FIELD_3 Character(15) VARCHAR2(15) NOT NULL User Field 3
    45 USER_FIELD_4 Character(20) VARCHAR2(20) NOT NULL User Field 4
    46 USER_FIELD_5 Character(20) VARCHAR2(20) NOT NULL User Field 5
    47 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
    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