A one character value that identifies the existence of a specific state or condition EMP OVERTIME INDICATOR EMP OVERTIME that has only two possible values or FACILITY CONTAM FACILITY CONTAM states, such as N or Y. If NULL or SPACE is INDICATOR HAZARDOUS number HAZARDOUS Indicator used as a possible value then this class LAND USE INDICATOR varchar2 LAND USE word should NOT be used since there OPS INDICATOR OPS would be three possible values for the CITIZEN INDICATOR CITIZEN field. The use of qualifier words is highly INDICATOR recommended to remove ambiguity. Used to define the primary key attribute of an entity. This attribute may be a system generated unique sequence number that acts as a surrogate key assigned to an entity to uniquely identify it or an attribute containing a unique data COMMENT KEY COMMENT KY value. A surrogate key implies that the ADDRESS KEY ADDRESS KY NBR key assignment is arbitrary and has no Key KEY number INCIDENT KEY INCIDENT KY SEQ business meaning. Please note that REMARK KEY REMARK SURROGATE NBR surrogate keys are guaranteed to be REMARK_KEY KEY unique, but are not necessarily consecutive. The Key class word is generally used when the value is not to the business user and is “visible” required for database activity. The class word should not be used by itself. The primary means of referring to a FIRST NAME FIRST NM person, place or thing. It may be end LAST NAME LAST NM user designated and is used when most PRIOR NAME NAME PRIOR Name NAME varchar2 natural from a business point of view. DIVISION NAME NAME OF DIVISION The use of qualifier words is highly POSITION TITLE NAME POSITION TITLE NM encouraged to reduce ambiguity. NAME NM or NME
Indicator number varchar2 A one character value that identifies the existence of a specific state or condition that has only two possible values or states, such as N or Y. If NULL or SPACE is used as a possible value then this class word should NOT be used since there would be three possible values for the field. The use of qualifier words is highly recommended to remove ambiguity. EMP OVERTIME FACILITY CONTAM HAZARDOUS LAND USE OPS CITIZEN EMP OVERTIME INDICATOR FACILITY CONTAM INDICATOR HAZARDOUS LAND USE INDICATOR OPS INDICATOR CITIZEN INDICATOR INDICATOR Key KEY number Used to define the primary key attribute of an entity. This attribute may be a system generated unique sequence number that acts as a surrogate key assigned to an entity to uniquely identify it or an attribute containing a unique data value. A surrogate key implies that the key assignment is arbitrary and has no business meaning. Please note that surrogate keys are guaranteed to be unique, but are not necessarily consecutive. The Key class word is generally used when the value is not “visible” to the business user and is required for database activity. The class word should not be used by itself. COMMENT KEY ADDRESS KEY INCIDENT KEY REMARK KEY REMARK_KEY COMMENT KY ADDRESS KY NBR INCIDENT KY SEQ REMARK SURROGATE NBR KEY Name NAME varchar2 The primary means of referring to a person, place or thing. It may be end user designated and is used when most natural from a business point of view. The use of qualifier words is highly encouraged to reduce ambiguity. FIRST NAME LAST NAME PRIOR NAME DIVISION NAME POSITION TITLE NAME NAME FIRST NM LAST NM NAME PRIOR NAME OF DIVISION POSITION TITLE NM NM or NME
STD-07092501.4.0_0.docx