EODI_APT_GROUP

(SQL Table)
Index Back

Appointment Group

Appointment Group

  • Related Language Record: EODI_APTGRP_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EODI_APT_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Apt Transaction ID
    2 EODI_APT_GROUP Character(5) VARCHAR2(5) NOT NULL Apt Group
    3 EODI_APT_GUID Character(150) VARCHAR2(150) NOT NULL Appointment GUID
    4 EODI_UNIQUE_INVITE Character(1) VARCHAR2(1) NOT NULL Use Unique Invite Flag

    Y/N Table Edit

    Default Value: N

    5 EODI_APT_MASTER Character(1) VARCHAR2(1) NOT NULL Appt. Master Flag

    Y/N Table Edit

    Default Value: Y

    6 EODI_APT_ICAL Character(1) VARCHAR2(1) NOT NULL iCal Flag

    Y/N Table Edit

    Default Value: N

    7 EODI_APT_STATUS Character(1) VARCHAR2(1) NOT NULL Apt Status
    A=Awaiting Responses
    C=Canceled
    H=On Hold - Do Not Schedule
    I=Initial - Not Visible
    Q=Queued For Scheduling
    S=Scheduled
    X=Queued For Canceling

    Default Value: I

    8 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    9 EODI_APT_SUBJECT Character(100) VARCHAR2(100) NOT NULL Apt Subject
    10 EODI_APT_LOCATION Character(254) VARCHAR2(254) NOT NULL Appointment Location
    11 EODI_CON_PROC_ID Character(15) VARCHAR2(15) NOT NULL Address Book Process ID

    Prompt Table: EODI_CON_APT_VW

    12 EODI_RESTRICT_ADDR Character(1) VARCHAR2(1) NOT NULL Restrict To Address Book

    Y/N Table Edit

    Default Value: N

    13 EODI_DURATION Number(3,0) SMALLINT NOT NULL Duration
    14 EODI_START_DTTM DateTime(26) TIMESTAMP Start Date/Time
    15 EODI_END_DTTM DateTime(26) TIMESTAMP End Date Time
    16 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    17 EODI_APT_ALLDAY Character(1) VARCHAR2(1) NOT NULL All Day Event
    18 EODI_APT_PRIORITY Character(1) VARCHAR2(1) NOT NULL Appointment Priority
    H=High
    L=Low
    N=Normal
    19 EODI_PRIVATE Character(1) VARCHAR2(1) NOT NULL Private

    Y/N Table Edit

    Default Value: N

    20 EODI_APT_REMINDER DateTime(26) TIMESTAMP Appointment Reminder
    21 EODI_DELETED Character(1) VARCHAR2(1) NOT NULL Deleted Flag

    Y/N Table Edit

    Default Value: N

    22 EODI_LAST_UP_DTTM DateTime(26) TIMESTAMP Last Update Date Time
    23 EODI_APT_SNT_DTTM DateTime(26) TIMESTAMP Apt Invitation Sent Date Time
    24 EODI_APT_SCH_DTTM DateTime(26) TIMESTAMP Apt Scheduled Date Time
    25 EODI_APT_DEL_DTTM DateTime(26) TIMESTAMP Apt Delete DateTime
    26 EODI_APT_CAN_DTTM DateTime(26) TIMESTAMP Apt Canceled DateTime
    27 EODI_MESSAGE Long Character CLOB Message