Definition of table site-table-code
Site Table Codes
, Table Dump Name sit-tblc
Alphabetical Field Summary
cre-date: (DATE) Date record was created
cre-time: (CHAR) Time record was created
cre-user-name: (CHAR) Name of user who created the record
description: (CHAR) Description of this table code entry
extern-guid: (CHAR) External Global Unique ID for this record
level-data[10]: (CHAR) Enter the level related data
table-code: (CHAR) Name of this table code entry
table-code-id: (INTG) Internally assigned Table Code ID [DEFINE KEY]
table-name-id: (INTG) Table Name this table belongs to
upd-date: (DATE) Date record was last updated
upd-time: (CHAR) Record last updated at
upd-user-name: (CHAR) Name of user record was updated by
Alphabetical Index Summary
description: table-name-id, description
extern-guid: extern-guid
table-code: table-name-id, table-code
table-code-id: (UNIQUE, PRIMARY) table-name-id, table-code-id
Alphabetical Trigger Summary
CREATE: Overridable, Procedure is tr-c-tbc.p (SOURCE NOT AVAILABLE)
DELETE: Overridable, Procedure is tr-d-tbc.p (SOURCE NOT AVAILABLE)
REPLICATION-CREATE: Procedure is rp-c-tbc.p (SOURCE NOT AVAILABLE)
REPLICATION-DELETE: Procedure is rp-d-tbc.p (SOURCE NOT AVAILABLE)
REPLICATION-WRITE: Procedure is rp-u-tbc.p (SOURCE NOT AVAILABLE)
WRITE: Overridable, Procedure is tr-u-tbc.p (SOURCE NOT AVAILABLE)
Other tables who reference site-table-code
course-catalog - Course Catalog
stu-note - Student Notes file
stu-site - Site Specific Student data file
stu-state-item - Describes a students state record entry
stu-title1-service - Student Title 1 Service
Tables site-table-code references
site-table-name - Site Table Names
Detailed Alphabetical Field Listing
cre-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date record was created
cre-time Data type: CHARACTER
Format: x(8)
Description: Time record was created
cre-user-name Data type: CHARACTER
Format: x(16)
Description: Name of user who created the record
description Data type: CHARACTER
Format: x(28)
Help: Description of this table code entry
Attributes: Index Component
extern-guid Data type: CHARACTER
Format: x(32)
Description: External Global Unique ID for this record
Attributes: Index Component
level-data Data type: CHARACTER (Extent: 10)
Format: x(28)
Help: Enter the level related data
table-code Data type: CHARACTER
Format: x(8)
Help: Name of this table code entry
Attributes: Index Component
table-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned Table Code ID [DEFINE KEY]
Attributes: Index Component
table-name-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Table Name this table belongs to
Attributes: Index Component
upd-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date record was last updated
upd-time Data type: CHARACTER
Format: x(8)
Description: Record last updated at
upd-user-name Data type: CHARACTER
Format: x(16)
Description: Name of user record was updated by
Created on 05/07/2012 by DBHTML V1.2