TL_ATTEND_PGM

(SQL Table)
Index Back

Attendance Program

  • Related Language Record: TL_ATTND_PG_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ATTENDANCE_PGM_ID Character(10) VARCHAR2(10) NOT NULL Attendance Program
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TL_ATTEND_PGM.DESCR

    5 TRACKING_METHOD Character(1) VARCHAR2(1) NOT NULL Tracking Method
    1=Fixed Period
    2=Rolling Period
    3=Step Period
    6 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Time Period ID

    Prompt Table: %EDITTABLE

    7 TRACK_IN Character(1) VARCHAR2(1) NOT NULL Track Tardies

    Y/N Table Edit

    8 TRACK_MEAL Character(1) VARCHAR2(1) NOT NULL Track Long Lunch

    Y/N Table Edit

    9 MINUTES_MEAL Number(3,0) SMALLINT NOT NULL Meal Duration (Minutes)
    10 TRACK_OUT Character(1) VARCHAR2(1) NOT NULL Track Early Out

    Y/N Table Edit

    11 TRACK_BREAK Character(1) VARCHAR2(1) NOT NULL Track Long Break

    Y/N Table Edit

    12 MINUTES_BREAK Number(3,0) SMALLINT NOT NULL Break Duration (Minutes)
    13 GRACE_IN Number(3,0) SMALLINT NOT NULL Grace (Minutes)
    14 GRACE_MEAL Number(2,0) SMALLINT NOT NULL Grace (Minutes)
    15 GRACE_OUT Number(3,0) SMALLINT NOT NULL Grace (Minutes)
    16 GRACE_BREAK Number(2,0) SMALLINT NOT NULL Grace (Minutes)
    17 POINTS_IN Number(6,2) DECIMAL(5,2) NOT NULL Tardy Points
    18 POINTS_MEAL Number(6,2) DECIMAL(5,2) NOT NULL Long Lunch Points
    19 POINTS_OUT Number(6,2) DECIMAL(5,2) NOT NULL Early Outk Points
    20 POINTS_BREAK Number(6,2) DECIMAL(5,2) NOT NULL Long Break Points