Open topic with navigation

DAILYSALEITEMPROGRAM (4.0SP6)

Holds data relative to a daily sale program item.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

PROGRAMID

uniqueidentifier

false

The ID of the program.

PRICETYPECODEID

uniqueidentifier

false

The ID of the price type code.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.
Fields
Field Field Type Null Notes Description

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

ISDAILYADMISSION

bit

false

1

Determines whether or not the program is a daily admission program.

SCHEDULEOPTIONTYPECODE

tinyint

false

0

Determines the scheduling options if the program is a scheduled program.

SCHEDULEOPTIONTYPE

nvarchar(38) (Computed)

true

Provides a translation for the 'SCHEDULEOPTIONTYPECODE' field.

SHOWALLDATES

bit

false

1

Determines whether the next available times are shown for all dates or only current date.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_DAILYSALEITEMPROGRAM_DATEADDED

DATEADDED

False

False

True

IX_DAILYSALEITEMPROGRAM_DATECHANGED

DATECHANGED

False

False

False

IX_DAILYSALEITEMPROGRAM_PROGRAMID

PROGRAMID

False

False

False

PK_DAILYSALEITEMPROGRAM

ID

True

True

False
Triggers
Trigger Name Description

TR_DAILYSALEITEMPROGRAM_AUDIT_UPDATE

TR_DAILYSALEITEMPROGRAM_AUDIT_DELETE