Definition of table rep-assign-code

REP Assignment Codes , Table Dump Name rep-assi

Alphabetical Field Summary

ace-option: (CHAR) (no description available)

assign-code: (CHAR) (no description available)

assign-code-id: (INTG) (no description available)

classes-option: (CHAR) (no description available)

cre-date: (DATE) Date this record was created

cre-time: (CHAR) Time this record was created

cre-user-name: (CHAR) Name of user who created this record

credential-option: (CHAR) (no description available)

degree-option: (CHAR) (no description available)

description: (CHAR) Description of this assign code

fte-option: (CHAR) (no description available)

function-option: (CHAR) (no description available)

funded-pos-option: (CHAR) (no description available)

hqs-option: (CHAR) (no description available)

is-core-subj: (LOGC) (no description available)

is-non-instr: (LOGC) (no description available)

is-parapro: (LOGC) (no description available)

is-sub: (LOGC) (no description available)

major-option: (CHAR) (no description available)

minor-option: (CHAR) (no description available)

prof-dev-option: (CHAR) (no description available)

sponsor-option: (CHAR) (no description available)

state-version-id: (INTG) Internally Assigned ID

title-1-option: (CHAR) (no description available)

upd-date: (DATE) Date this record was last updated on

upd-time: (CHAR) Date this record was last updated

upd-user-name: (CHAR) Name of user who last updated this record

wage-option: (CHAR) (no description available)

Alphabetical Index Summary

assign-code: state-version-id, assign-code

rep-assign-code: (UNIQUE, PRIMARY) state-version-id, assign-code-id

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-rac.p

DELETE: Overridable, Procedure is tr-d-rac.p

WRITE: Overridable, Procedure is tr-u-rac.p

Tables rep-assign-code references

state-version - Date versioning

Detailed Alphabetical Field Listing
ace-option Data type: CHARACTER
Format: x(8)

assign-code Data type: CHARACTER
Format: x(8)
Attributes: Index Component

assign-code-id Data type: INTEGER
Format: ->,>>>,>>9
Attributes: Index Component

classes-option Data type: CHARACTER
Format: x(8)

cre-date Data type: DATE
Format: 99/99/99
Help: Date this record was created

cre-time Data type: CHARACTER
Format: x(8)
Help: Time this record was created

cre-user-name Data type: CHARACTER
Format: x(16)
Help: Name of user who created this record

credential-option Data type: CHARACTER
Format: x(8)

degree-option Data type: CHARACTER
Format: x(8)

description Data type: CHARACTER
Format: x(28)
Help: Description of this assign code

fte-option Data type: CHARACTER
Format: x(8)

function-option Data type: CHARACTER
Format: x(8)

funded-pos-option Data type: CHARACTER
Format: x(8)

hqs-option Data type: CHARACTER
Format: x(8)

is-core-subj Data type: LOGICAL
Format: yes/no (Initial Value: no)

is-non-instr Data type: LOGICAL
Format: yes/no (Initial Value: no)

is-parapro Data type: LOGICAL
Format: yes/no (Initial Value: no)

is-sub Data type: LOGICAL
Format: yes/no (Initial Value: no)

major-option Data type: CHARACTER
Format: x(8)

minor-option Data type: CHARACTER
Format: x(8)

prof-dev-option Data type: CHARACTER
Format: x(8)

sponsor-option Data type: CHARACTER
Format: x(8)

state-version-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally Assigned ID
Attributes: Index Component

title-1-option Data type: CHARACTER
Format: x(8)

upd-date Data type: DATE
Format: 99/99/99
Help: Date this record was last updated on

upd-time Data type: CHARACTER
Format: x(8)
Help: Date this record was last updated

upd-user-name Data type: CHARACTER
Format: x(16)
Help: Name of user who last updated this record

wage-option Data type: CHARACTER
Format: x(8)

Created on 11/14/2011 by DBHTML V1.2