TL_RAPID_HEADER

(SQL Table)
 Index Back

T&L Rapid Entry Header

T&L Rapid Entry Header Record for Release 8.0 +

  • Parent Record Of FO_RPD_PTIME_VW FO_RPD_TIME_VW FO_TL_RPDTM_T2W FO_TL_RPDTM_T3W FO_TL_RPDTM_TA2 FO_TL_RPDTM_TA3 TL_RAPID_PTIME TL_RAPID_TIME TL_RAPID_T_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ST_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Session Number

    Default Value: 9999999999

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 RAPID_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Rapid Time Template

    Prompt Table: %EDITTABLE8

    4 TL_ADDREP_IND Character(1) VARCHAR2(1) NOT NULL This field designates whether time should be added to or replace a particular day's time.
    A=Addition
    C=Correction
    R=Replacement

    Default Value: R

    5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    6 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default Value: %Datetime

    7 RAPID_UPDATE_FLAG Character(1) VARCHAR2(1) NOT NULL Session Status
    0=Not Submitted
    1=Submitted to Reported Time
    2=Submitted to Time Administrati
    3=Need to Resubmit the Session

    Default Value: 0