RDB PRIME!
Engineering
Home
Research Paper(s)
Resume
Technology Items
Site Map
Site Search
 
 It is 08:54 PST on Friday 03/29/2024

Alert System

RDB PRIME INC. -- Engineering

Created by: Robert Betterton

Date: Thursday, Nov 1, 2001

Time: 08:54


Table of Contents

  1. Data Models
    1. Main
  2. Data Dictionary

Data Models

Document: AlertSystem.erd


Data Model

Image of Main

1 Main

Related Diagrams:

None:

Related Dictionary Entries:

Entities/Tables:

XRX_CLOSED_ALERT
XRX_CUSTOMER_INFO
XRX_HELP
XRX_LOOKUP_CODES
XRX_LOOKUP_TYPES
XRX_MEDIACONSUM_INFO
XRX_NETCOMP_INFO
XRX_NEW_ALERT
XRX_PRODUCT_INFO
XRX_UPDATE_ALERT

Relationships:

LOOKUP_T_LOOKUP_C
NA_CA
NA_CUSTOMER
NA_MEDIACONSUM
NA_NETCOMP
NA_PRODUCT
NA_UA

Return To Contents


Data Dictionary

Name: 100VAC-60Hz
Composition:

Definition:
This is part of a drop down menu item for the Attribute INPUT_MAINS
References:
MENU

Name: 1024
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTES MEMORY_AMT, COMPUTER_MEMORY_AMT in MB
References:
MENU

Name: 110-120VAC-60Hz
Composition:

Definition:
This is part of a drop down menu item for the Attribute INPUT_MAINS
References:
MENU

Name: 128
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTES MEMORY_AMT, COMPUTER_MEMORY_AMT in MB
References:
MENU

Name: 16
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTES MEMORY_AMT, COMPUTER_MEMORY_AMT in MB
References:
MENU

Name: 220-240VAC-50Hz
Composition:

Definition:
This is part of a drop down menu item for the Attribute INPUT_MAINS
References:
MENU

Name: 256
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTES MEMORY_AMT, COMPUTER_MEMORY_AMT in MB
References:
MENU

Name: 300dpi
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRINT_MODE
References:
MENU

Name: 32
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTES MEMORY_AMT, COMPUTER_MEMORY_AMT in MB
References:
MENU

Name: 4
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTES MEMORY_AMT, COMPUTER_MEMORY_AMT in MB
References:
MENU

Name: 4697-Roll
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: 512
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE MEMORY_AMT, COMPUTER_MEMORY_AMT in MB
References:
MENU

Name: 600x300dpi
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRINT_MODE
References:
MENU

Name: 64
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTES MEMORY_AMT, COMPUTER_MEMORY_AMT in MB
References:
MENU

Name: 8
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTES MEMORY_AMT, COMPUTER_MEMORY_AMT in MB
References:
MENU

Name: A-Paper
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: A-Transparency
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: A3-Paper
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: A4-Paper
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: A4-Transparency
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: AppleTalk
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE NETWORK_CARD_SETUP
References:
MENU

Name: Artist-Pres-Canvas
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: B-Paper
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: Backlit-Display-36
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: Business-Office
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE CUSTOMER_ENVIR
References:
MENU

Name: Canada
Composition:
Definition:
This is part of a drop down menu item for the ATTRIBUTE REGION
References:
MENU

Name: CLOSED
Composition:
Definition:
This is a closed alert designation for menu element of the ATTRIBUTE ALERT_STATUS
References:
MENU

Name: Commercial
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COLOR_CORRECTION
References:
MENU

Name: Could-Cause-a-Lawsuit
Composition:

Definition:
This is part of a drop down menu item for the Attribute PRIORITY_IMPACT
References:
MENU

Name: Could-Effect-Customer-Relations
Composition:

Definition:
This is part of a drop down menu item for the Attribute PRIORITY_IMPACT
References:
MENU

Name: Could-Effect-Marketing
Composition:

Definition:
This is part of a drop down menu item for the Attribute PRIORITY_IMPACT
References:
MENU

Name: Could-Effect-Sales
Composition:

Definition:
This is part of a drop down menu item for the Attribute PRIORITY_IMPACT
References:
MENU

Name: DIMM-Style
Composition:
Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE TYPE_NETWORK_CARD
References:
MENU

Name: Display
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COLOR_CORRECTION
References:
MENU

Name: Display-Vinyl
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: E-Paper
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: Eastern-Europe
Composition:
Definition:
This is part of a drop down menu item for the ATTRIBUTE REGION
References:
MENU

Name: Enhanced
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRINT_MODE
References:
MENU

Name: Enhanced-Z350
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRINT_MODE
References:
MENU

Name: EtherNet
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COMM_PORT
References:
MENU

Name: EtherTalk
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COMM_PORT, NETWORK_CARD_SETUP
References:
MENU

Name: Europe
Composition:
Definition:
This is part of a drop down menu item for the ATTRIBUTE REGION
References:
MENU

Name: Euroscale
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COLOR_CORRECTION
References:
MENU

Name: Factory-Floor
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE CUSTOMER_ENVIR
References:
MENU

Name: Fast
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRINT_MODE
References:
MENU

Name: Fast-Color
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRINT_MODE
References:
MENU

Name: Field-Studies
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE CUSTOMER_ENVIR
References:
MENU

Name: FireWire
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COMM_PORT
References:
MENU

Name: Focal-Point-Names-ED
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE FACTORY_FOCAL_POINT
References:
MENU

Name: Focal-Point-Names-ST
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE FACTORY_FOCAL_POINT
References:
MENU

Name: Graphics-Art-Studio
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE CUSTOMER_ENVIR
References:
MENU

Name: High-Gloss-Lamination
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: Japan
Composition:
Definition:
This is part of a drop down menu item for the ATTRIBUTE REGION
References:
MENU

Name: Labels
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: Latin-America
Composition:
Definition:
This is part of a drop down menu item for the ATTRIBUTE REGION
References:
MENU

Name: LocalTalk
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COMM_PORT
References:
MENU

Name: LOOKUP_T_LOOKUP_C
Composition:
Definition:
This is the relationship name between the entity XRX_LOOKUP_TYPE and XRX_LOOKUP_CODES
References:
ERD(RELATION) "AlertSystem.erd" "Main"

Name: Miliary-Exercises
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE CUSTOMER_ENVIR
References:
MENU

Name: Monochorme
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COLOR_CORRECTION
References:
MENU

Name: N-A
Composition:
Definition:
This is part of a drop down menu item for the ATTRIBUTE INPUT_MAINS, MEDIA_TYPE, CUSTOMER_ENVIR, COMM_PORT, PRINT_MODE
References:
MENU

Name: Naval-Ship
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE CUSTOMER_ENVIR
References:
MENU

Name: NA_CA
Composition:
Definition:
This is the relationship name between the entity XRX_NEW_ALERT and XRX_CLOSED_ALERT
References:
ERD(RELATION) "AlertSystem.erd" "Main"

Name: NA_CUSTOMER
Composition:
Definition:
This is the relationship name between the entity XRX_NEW_ALERT and XRX_CUSTOMER_INFO
References:
ERD(RELATION) "AlertSystem.erd" "Main"

Name: NA_MEDIACONSUM
Composition:
Definition:
This is the relationship name between the entity XRX_NEW_ALERT and XRX_MEDIACONSUM_INFO
References:
ERD(RELATION) "AlertSystem.erd" "Main"

Name: NA_NETCOMP
Composition:
Definition:
This is the relationship name between the entity XRX_NEW_ALERT and XRX_NETCOMP_INFO
References:
ERD(RELATION) "AlertSystem.erd" "Main"

Name: NA_PRODUCT
Composition:
Definition:
This is the relationship name between the entity XRX_NEW_ALERT and XRX_PRODUCT_INFO
References:
ERD(RELATION) "AlertSystem.erd" "Main"
EVENT

Name: NA_UA
Composition:
Definition:
This is the relationship name between the entity XRX_NEW_ALERT and XRX_UPDATE_ALERT

#Details
Parent: ()
Child: ()
##
#ActionCode
##
References:
ERD(RELATION) "AlertSystem.erd" "Main"

Name: NetWare
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE NETWORK_CARD_SETUP
References:
MENU

Name: NEW
Composition:
Definition:
This is a closed alert designation for menu element of the ATTRIBUTE ALERT_STATUS
References:
MENU

Name: None
Composition:
Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COLOR_CORRECTION
References:
MENU

Name: Northeast-US
Composition:
Definition:
This is part of a drop down menu item for the ATTRIBUTE REGION
References:
MENU

Name: Other...
Composition:

Definition:
This is part of a drop down menu item for the ATTRIBUTE INPUT_MAINS, MEDIA_TYPE, CUSTOMER_ENVIR, COMM_PORT, PRINT_MODE
References:
MENU

Name: Pacific-Rim
Composition:

Definition:
This is part of a drop down menu item for the ATTRIBUTE REGION
References:
MENU

Name: Parallel
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COMM_PORT
References:
MENU

Name: Part-Of-IP_Bd
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE TYPE_NETWORK_CARD
References:
MENU

Name: Persentation
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRINT_MODE
References:
MENU

Name: Phaser-140
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-200i-e
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-220i-e
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-240
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-300i
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-300x
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-340-350
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-360
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-380
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-440
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-450
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-480
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-480X
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-540
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-540P
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-560
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-600
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-740
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-750
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-780
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-790
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-840
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-850
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-860
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-I
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-II
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-II-SD-SDX
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-III
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Phaser-III-RX
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE PRODUCT_MODEL
References:
MENU

Name: Photo-Grade-Pres-24
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: Photo-Grade-Pres-36
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: Prem-Tracing-Backlit
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: Premium
Composition:
Definition:
References:

Name: Print-Shop
Composition:
Definition:
This an element-item of a dropdown menu for the ATTRIBUTE CUSTOMER_ENVIR
References:
MENU

Name: Residence
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE CUSTOMER_ENVIR
References:
MENU

Name: Respositionable-Adh
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: Retail
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE CUSTOMER_ENVIR
References:
MENU

Name: SCSI
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COMM_PORT
References:
MENU

Name: Serial
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COMM_PORT, NETWORK_CARD_SETUP
References:
MENU

Name: Shop-Floor
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE CUSTOMER_ENVIR
References:
MENU

Name: SIMM-Style
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE TYPE_NETWORK_CARD
References:
MENU

Name: Slide-In
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE TYPE_NETWORK_CARD
References:
MENU

Name: Smooth-White-Bond-24
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: Smooth-White-Bond-36
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: Southeast-US
Composition:

Definition:
This is part of a drop down menu item for the ATTRIBUTE REGION
References:
MENU

Name: SWOP
Composition:

Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE COLOR_CORRECTION
References:
MENU

Name: T-Shirt-Transfer
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: TCP-IP
Composition:
Definition:
This is an element-item of a dropdown menu for the ATTRIBUTE NETWORK_CARD_SETUP
References:
MENU

Name: Transparent-36
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: Traveling-Exhibit
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE CUSTOMER_ENVIR
References:
MENU

Name: UPDATE
Composition:
Definition:
This is a closed alert designation for menu element of the ATTRIBUTE ALERT_STATUS
References:
MENU

Name: US-Legal
Composition:
Definition:
This an element-item of a dropdown menu for the ATTRIBUTE MEDIA_TYPE
References:
MENU

Name: USB
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COMM_PORT
References:
MENU

Name: Vivid-Color
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE COLOR_CORRECTION
References:
MENU

Name: Warehouse
Composition:

Definition:
This an element-item of a dropdown menu for the ATTRIBUTE CUSTOMER_ENVIR
References:
MENU

Name: West-US
Composition:

Definition:
This is part of a drop down menu item for the ATTRIBUTE REGION
References:
MENU

Name: Will-Cause-a-Lawsuit
Composition:

Definition:
This is part of a drop down menu item for the ATTRIBUTE PRIORITY_IMPACT
References:
MENU

Name: Will-Effect-Customer-Relations
Composition:

Definition:
This is part of a drop down menu item for the ATTRIBUTE PRIORITY_IMPACT
References:
MENU

Name: Will-Effect-Marketing
Composition:

Definition:
This is part of a drop down menu item for the ATTRIBUTE PRIORITY_IMPACT
References:
MENU

Name: Will-Effect-Sales
Composition:

Definition:
This is part of a drop down menu item for the ATTRIBUTE PRIORITY_IMPACT
References:
MENU

Name: XRX_CLOSED_ALERT
Composition:
*XRX_CLOSED_ALERT'CA_ID +
@XRX_CLOSED_ALERT'ALERT_NUMBER +
XRX_CLOSED_ALERT'ALERT_STATUS +
XRX_CLOSED_ALERT'CLOSURE_DATE +
XRX_CLOSED_ALERT'CLOSED_BY +
XRX_CLOSED_ALERT'REASON_FOR_CLOSURE +
XRX_CLOSED_ALERT'TOTAL_DAYS_OPENED
Definition:


Closed Alert Info

#TableCode
##
#Notes
##
#Details
Physical: XRX_CLOSED_ALERT
#
#ViewCode
##
References:
ERD(ENTITY) "AlertSystem.erd" "Main"

Name: XRX_CLOSED_ALERT'ALERT_NUMBER
Composition:
Alert is entered. This is also identified as a FK>
Definition:
#Details
DataType: NUMBER(6)
Describe: Number of an alert - currently alert numbers take on the current format CP[ordered number]-[four digit year]. They are currently entered by the Administrator. The system must now generate this number automaitcally.
Qualify: notnull
Physical: ALERT_NUMBER
##
References:
ATTRIBUTE

Name: XRX_CLOSED_ALERT'ALERT_STATUS
Composition:
[NEW|UPDATE|CLOSED]
Definition:
#Details
DataType: VARCHAR2(10)
Describe: Status of an alert - it is either NEW, UPDATE, or CLOSED, these are hidden text fields on the ColdFusion forms.
Qualify: notnull
Physical: ALERT_STATUS
##
References:
ATTRIBUTE

Name: XRX_CLOSED_ALERT'CA_ID
Composition:
Definition:
#Details
DataType: NUMBER
Describe: This is the auto serial number [sequence] for the tuple.
Qualify: notnull
Physical: CA_ID
##
References:
ATTRIBUTE

Name: XRX_CLOSED_ALERT'CLOSED_BY
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: ONLY the ORIGINATOR OR ADMIN can close and an ALERT. Thus a check needs to be made between current on line user and oringinator of ALERT being closed.
Qualify: notnull
Physical: CLOSED_BY
##
References:
ATTRIBUTE

Name: XRX_CLOSED_ALERT'CLOSURE_DATE
Composition:
Definition:
#Details
DataType: DATE
Describe: What is the alert closure date - auto filed when selection is made in text box or on onload.
Qualify: notnull
Physical: CLOSURE_DATE
##
References:
ATTRIBUTE

Name: XRX_CLOSED_ALERT'REASON_FOR_CLOSURE
Composition:
Definition:
#Details
DataType: VARCHAR2(2000)
Describe: What is the reason for closing this Alert -- This is a textArea on the web ColdFusion templet.
Qualify: notnull
Physical: REASON_FOR_CLOSURE
##
References:
ATTRIBUTE

Name: XRX_CLOSED_ALERT'TOTAL_DAYS_OPENED
Composition:
Definition:
#Details
DataType: NUMBER(3)
Describe: This is a calculation done by the database per method/function. The calculation is done from the date the Alert was opened to the date that the alert was closed.
Qualify: notnull
Physical: TOTAL_DAYS_OPENED
##
References:
ATTRIBUTE

Name: XRX_CUSTOMER_INFO
Composition:
*XRX_CUSTOMER_INFO'CI_ID +
@XRX_CUSTOMER_INFO'ALERT_NUMBER +
XRX_CUSTOMER_INFO'ACCOUNT_NAME +
XRX_CUSTOMER_INFO'JOB_NUMBER +
XRX_CUSTOMER_INFO'CUSTOMER_CONTACT +
XRX_CUSTOMER_INFO'CUSTOMER_PHONE +
XRX_CUSTOMER_INFO'CUSTOMER_ENVIR +
XRX_CUSTOMER_INFO'CUSTOMER_COUNTRY
Definition:


Customer Infod
References:
ERD(ENTITY) "AlertSystem.erd" "Main"

Name: XRX_CUSTOMER_INFO'ACCOUNT_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the Account name for the Customer - this field is a web templet text box. This could also hold the ORACLE customer ID.
Qualify: notnull
Physical: ACCOUNT_NAME
##
References:
ATTRIBUTE

Name: XRX_CUSTOMER_INFO'ALERT_NUMBER
Composition:

Definition:
#Details
DataType: NUMBER(6)
Describe: Number of an alert - currently alert numbers take on the current format CP[number]-[four digit year]. The are currently entered in by the Administrator. The system must now generate this number automaitcally.
Qualify: notnull
Physical: ALERT_NUMBER
##
References:
ATTRIBUTE

Name: XRX_CUSTOMER_INFO'CI_ID
Composition:
Definition:
#Details
DataType: NUMBER
Describe: This is the auto serial number [sequence] for the tuple.
Qualify: notnull
Physical: CI_ID
##
References:
ATTRIBUTE

Name: XRX_CUSTOMER_INFO'CUSTOMER_CONTACT
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the customers contact person(s) - this field is a web templet text box.
Qualify: notnull
Physical: CUSTOMER_CONTACT
##
References:
ATTRIBUTE

Name: XRX_CUSTOMER_INFO'CUSTOMER_COUNTRY
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the the customers country where the printer is housed.
Physical: CUSTOMER_COUNTRY
##
References:
ATTRIBUTE

Name: XRX_CUSTOMER_INFO'CUSTOMER_ENVIR
Composition:
[N-A|Business-Office|Factory-Floor|Field-Studies|Graphics-Art-Studio] +
[Naval-Ship|Print-Shop|Residence|Retail|Shop-Floor|Traveling-Exhibit] +
[Warehouse|Miliary-Exercises|Other...]
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the customer Environment - this field on the web templete is filled from a drop down list recieved from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Qualify: notnull
Physical: CUSTOMER_ENVIR
##
References:
ATTRIBUTE

Name: XRX_CUSTOMER_INFO'CUSTOMER_PHONE
Composition:
Definition:
#Details
DataType: VARCHAR2(25)
Describe: This is the customers phone number(s) - this field is a web templet text box. Field length is set up to handle international phone numbers.
Qualify: notnull
Physical: CUSTOMER_PHONE
##
References:
ATTRIBUTE

Name: XRX_CUSTOMER_INFO'JOB_NUMBER
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the customers job number - this field is a web templet text box. It is an alphanumeric stamp.
Physical: JOB_NUMBER
##
References:
ATTRIBUTE

Name: XRX_HELP
Composition:
*XRX_HELP'HELP_ID +
XRX_HELP'TOPIC +
XRX_HELP'DESCRIPTION +
XRX_HELP'DATE_STAMP_SH +
XRX_HELP'DISABLED
Definition:


Help Systemt
References:
ERD(ENTITY) "AlertSystem.erd" "Main"

Name: XRX_HELP'DATE_STAMP_SH
Composition:
Definition:
#Details
DataType: DATE
Describe: This is a SYSDATE auto generated Date.
Qualify: notnull
Default: SYSDATE
Physical: DATE_STAMP_SH
##
References:
ATTRIBUTE

Name: XRX_HELP'DESCRIPTION
Composition:
Definition:
#Details
DataType: VARCHAR2(2000)
Describe: Give the help topic a description.
Physical: DESCRIPTION
##
References:
ATTRIBUTE

Name: XRX_HELP'DISABLED
Composition:
Definition:
#Details
DataType: NUMBER(2)
Describe: The disabled field takes on the a value of 0 or 1.
Qualify: notnull
Default: 0
Physical: DISABLED
##
References:
ATTRIBUTE

Name: XRX_HELP'HELP_ID
Composition:
Definition:
#Details
DataType: NUMBER
Describe: This is the auto serial number [sequence] for the tuple.
Qualify: notnull
Physical: HELP_ID
##
References:
ATTRIBUTE

Name: XRX_HELP'TOPIC
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: Give the Help topic a name.
Physical: TOPIC
##
References:
ATTRIBUTE

Name: XRX_LOOKUP_CODES
Composition:
*XRX_LOOKUP_CODES'LUC_ID +
@XRX_LOOKUP_CODES'LOOKUP_TYPE +
XRX_LOOKUP_CODES'LOOKUP_CODE +
XRX_LOOKUP_CODES'DESCRIPTION +
XRX_LOOKUP_CODES'DATE_STAMP_LUC +
XRX_LOOKUP_CODES'DISABLED
Definition:


Menu Items Elementsn
References:
ERD(ENTITY) "AlertSystem.erd" "Main"

Name: XRX_LOOKUP_CODES'DATE_STAMP_LUC
Composition:
Definition:
#Details
DataType: DATE
Describe: This is a SYSDATE auto generated Date.
Default: SYSDATE
Physical: DATE_STAMP_LUC
##
References:
ATTRIBUTE

Name: XRX_LOOKUP_CODES'DESCRIPTION
Composition:
Definition:
#Details
DataType: VARCHAR2(200)
Describe: This describes the lookup menu element.
Physical: DESCRIPTION
##
References:
ATTRIBUTE

Name: XRX_LOOKUP_CODES'DISABLED
Composition:
Definition:
#Details
DataType: NUMBER(2)
Describe: The disabled field takes on the a value of 0 or 1.
Default: 0
Physical: DISABLED
##
References:
ATTRIBUTE

Name: XRX_LOOKUP_CODES'LOOKUP_CODE
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the lookup element item used in the drop down menu.
Physical: LOOKUP_CODE
##
References:
ATTRIBUTE

Name: XRX_LOOKUP_CODES'LOOKUP_TYPE
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the lookup name used for the dropdown menu.
Qualify: notnull
Physical: LOOKUP_TYPE
##
References:
ATTRIBUTE

Name: XRX_LOOKUP_CODES'LUC_ID
Composition:
Definition:
#Details
DataType: NUMBER
Describe: This is the auto serial number [sequence] for the tuple.
Qualify: notnull
Physical: LUC_ID
##
References:
ATTRIBUTE

Name: XRX_LOOKUP_TYPES
Composition:
*XRX_LOOKUP_TYPES'LUT_ID +
*XRX_LOOKUP_TYPES'LOOKUP_TYPE +
XRX_LOOKUP_TYPES'DESCRIPTION +
XRX_LOOKUP_TYPES'DATE_STAMP_LUT +
XRX_LOOKUP_TYPES'DISABLED
Definition:


Menu Names-
References:
ERD(ENTITY) "AlertSystem.erd" "Main"

Name: XRX_LOOKUP_TYPES'DATE_STAMP_LUT
Composition:
Definition:
#Details
DataType: DATE
Describe: This is a SYSDATE auto generated Date.
Default: SYSDATE
Physical: DATE_STAMP_LUT
##
References:
ATTRIBUTE

Name: XRX_LOOKUP_TYPES'DESCRIPTION
Composition:
Definition:
#Details
DataType: VARCHAR2(200)
Describe: This describes the lookup menu name.
Physical: DESCRIPTION
##
References:
ATTRIBUTE

Name: XRX_LOOKUP_TYPES'DISABLED
Composition:
Definition:
#Details
DataType: NUMBER(2)
Describe: The disabled field takes on the a value of 0 or 1.
Default: 0
Physical: DISABLED
##
References:
ATTRIBUTE

Name: XRX_LOOKUP_TYPES'LOOKUP_TYPE
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the lookup name used for the dropdown menu.
Qualify: notnull
Physical: LOOKUP_TYPE
##
References:
ATTRIBUTE

Name: XRX_LOOKUP_TYPES'LUT_ID
Composition:
Definition:
#Details
DataType: NUMBER
Describe: This is the auto serial number [sequence] for the tuple.
Qualify: notnull
Physical: LUT_ID
##
References:
ATTRIBUTE

Name: XRX_MEDIACONSUM_INFO
Composition:
*XRX_MEDIACONSUM_INFO'MAI_ID +
@XRX_MEDIACONSUM_INFO'ALERT_NUMBER +
XRX_MEDIACONSUM_INFO'MEDIA_TYPE +
XRX_MEDIACONSUM_INFO'MEDIA_PN +
XRX_MEDIACONSUM_INFO'MEDIA_BOND +
XRX_MEDIACONSUM_INFO'NONE_OPB_MEDIA_TYPE +
XRX_MEDIACONSUM_INFO'LOT_NUMBER +
XRX_MEDIACONSUM_INFO'CONSUMABLES_USED
Definition:


Media and Consumables Usedo
References:
ERD(ENTITY) "AlertSystem.erd" "Main"

Name: XRX_MEDIACONSUM_INFO'ALERT_NUMBER
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: Number of an alert - currently alert numbers take on the current format CP[number]-[four digit year]. The are currently entered in by the Administrator. The system must now generate this number automaitcally.
Qualify: notnull
Physical: ALERT_NUMBER
##
References:
ATTRIBUTE

Name: XRX_MEDIACONSUM_INFO'CONSUMABLES_USED
Composition:
Definition:
#Details
DataType: VARCHAR2(100)
Describe: What consumables have been used. List them.
Physical: CONSUMABLES_USED
##
References:
ATTRIBUTE

Name: XRX_MEDIACONSUM_INFO'LOT_NUMBER
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is lot number for the media type.
Physical: LOT_NUMBER
##
References:
ATTRIBUTE

Name: XRX_MEDIACONSUM_INFO'MAI_ID
Composition:
Definition:
#Details
DataType: NUMBER
Describe: This is the auto serial number [sequence] for the tuple.
Qualify: notnull
Physical: MAI_ID
##
References:
ATTRIBUTE

Name: XRX_MEDIACONSUM_INFO'MEDIA_BOND
Composition:
Definition:
#Details
DataType: NUMBER
Describe: What is the media bond weight designation - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: MEDIA_BOND
##
References:
ATTRIBUTE

Name: XRX_MEDIACONSUM_INFO'MEDIA_PN
Composition:
Definition:
#Details
DataType: VARCHAR2(20)
Describe: What is the part number for the media being used - this field is a web templet text box.
Physical: MEDIA_PN
##
References:
ATTRIBUTE

Name: XRX_MEDIACONSUM_INFO'MEDIA_TYPE
Composition:
[N-A|A-Paper|A3-Paper|A4-Paper|B-Paper|E-Paper|US-Legal|A-Transparency] +
[A4-Transparency|T-Shirt-Transfer|Labels|4697-Roll|Smooth-White-Bond-24] +
[Smooth-White-Bond-36|Photo-Grade-Pres-24|Photo-Grade-Pres-36] +
[Prem-Tracing-Backlit|Transparent-36|Backlit-Display-36|Respositionable-Adh] +
[Display-Vinyl|Artist-Pres-Canvas|High-Gloss-Lamination|Other...]
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What type of media is being used - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: MEDIA_TYPE
##
References:
ATTRIBUTE

Name: XRX_MEDIACONSUM_INFO'NONE_OPB_MEDIA_TYPE
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the OPB Non-Xerox Media Type being used.
Physical: NONE_OPB_MEDIA_TYPE
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO
Composition:
*XRX_NETCOMP_INFO'MCI_ID +
@XRX_NETCOMP_INFO'ALERT_NUMBER +
XRX_NETCOMP_INFO'COMPUTER_MODEL +
XRX_NETCOMP_INFO'COMPUTER_OS_VERSION +
XRX_NETCOMP_INFO'COMPUTER_MEMORY_AMT +
XRX_NETCOMP_INFO'COMPUTER_TYPE +
XRX_NETCOMP_INFO'COMPUTER_APPS +
XRX_NETCOMP_INFO'COMPUTER_OS +
XRX_NETCOMP_INFO'COMPUTER_PRINT_DRVS +
XRX_NETCOMP_INFO'COMPUTER_NIC_TYPE +
XRX_NETCOMP_INFO'NETWORK_ARCHIT +
XRX_NETCOMP_INFO'NETWORK_OS +
XRX_NETCOMP_INFO'NETWORK_OS_VERSION +
XRX_NETCOMP_INFO'NETWORK_SERV_MEM_AMT +
XRX_NETCOMP_INFO'NETWORK_PROTOCOL +
XRX_NETCOMP_INFO'NETWORK_TOPOLOGY +
XRX_NETCOMP_INFO'NETWORK_SERVER_TYPES +
XRX_NETCOMP_INFO'NETWORk_CABLING_TYPE
Definition:


Network and Computer Infoo
References:
ERD(ENTITY) "AlertSystem.erd" "Main"

Name: XRX_NETCOMP_INFO'ALERT_NUMBER
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: Number of an alert - currently alert numbers take on the current format CP[number]-[four digit year]. The are currently entered in by the Administrator. The system must now generate this number automaitcally.
Qualify: notnull
Physical: ALERT_NUMBER
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'COMPUTER_APPS
Composition:
Definition:
#Details
DataType: VARCHAR2(200)
Describe: List the computer applications sending prints to the printer-product - this field is a web templet text area box.
Physical: COMPUTER_APPS
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'COMPUTER_MEMORY_AMT
Composition:
[N-A|4|8|16|32|64|128|256|512|1024|Other...]
Definition:
#Details
DataType: NUMBER
Describe: How much memory does the computer have - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: COMPUTER_MEMORY_AMT
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'COMPUTER_MODEL
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is computer models being used to commicate with the printer-product - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: COMPUTER_MODEL
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'COMPUTER_NIC_TYPE
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the computer network internet card being used - this field is a web templet text box.
Physical: COMPUTER_NIC_TYPE
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'COMPUTER_OS
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the computer operating system - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: COMPUTER_OS
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'COMPUTER_OS_VERSION
Composition:
Definition:
#Details
DataType: VARCHAR2(20)
Describe: What is the computer Operating System version being used - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: COMPUTER_OS_VERSION
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'COMPUTER_PRINT_DRVS
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What are the computer printer-product drivers being used - this field is a web templet text box.
Physical: COMPUTER_PRINT_DRVS
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'COMPUTER_TYPE
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: Whai is the computer type sending prints to the printer - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: COMUTER_TYPE
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'MCI_ID
Composition:
Definition:
#Details
DataType: NUMBER
Describe: This is the auto serial number [sequence] for the tuple.
Qualify: notnull
Physical: MCI_ID
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'NETWORK_ARCHIT
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the network architecture - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: NETWORK_ARCHIT
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'NETWORk_CABLING_TYPE
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is network cabling in use - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: NETWORK_CABLING_TYPE
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'NETWORK_OS
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the Network Operating System - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: NETWORK_OS
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'NETWORK_OS_VERSION
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the Network OS Version - this field is a web templet text box.
Physical: NETWORK_OS_VERSION
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'NETWORK_PROTOCOL
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the network protocol being used - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Default: N/A
Physical: NETWORK_PROTOCOL
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'NETWORK_SERVER_TYPES
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the Network server being used - this field is a web templet text box.
Physical: NETWORK_SERVER_TYPES
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'NETWORK_SERV_MEM_AMT
Composition:
Definition:
#Details
DataType: NUMBER
Describe: What is the network server memory amount - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: NETWORK_SERV_MEM_AM
##
References:
ATTRIBUTE

Name: XRX_NETCOMP_INFO'NETWORK_TOPOLOGY
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the network topology the printer is attached to - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: NETWORK_TOPOLOGY
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT
Composition:
*XRX_NEW_ALERT'NA_ID +
*XRX_NEW_ALERT'ALERT_NUMBER +
XRX_NEW_ALERT'ALERT_STATUS +
XRX_NEW_ALERT'DATE_OPENED +
XRX_NEW_ALERT'ORIGINATED_BY +
XRX_NEW_ALERT'REGION +
XRX_NEW_ALERT'EMAIL +
XRX_NEW_ALERT'FIELD_OFFICE +
XRX_NEW_ALERT'PHONE_NUMBER +
XRX_NEW_ALERT'FAX_NUMBER +
XRX_NEW_ALERT'ADD_FIELD_PERSONNEL +
XRX_NEW_ALERT'PROBLEM_DESCRIPTION +
XRX_NEW_ALERT'WHAT_HAVE_YOU_DONE +
XRX_NEW_ALERT'PRIORITY_IMPACT +
XRX_NEW_ALERT'MANAGER_APPROVAL
Definition:


New Alert Info
References:
ERD(ENTITY) "AlertSystem.erd" "Main"

Name: XRX_NEW_ALERT'ADD_FIELD_PERSONNEL
Composition:
Definition:
#Details
DataType: VARCHAR2(100)
Describe: Originator can add addional field personnel they feel sould be notified about this ALERT by the automated Email.
Physical: ADD_FIELD_PERSONNEL
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'ALERT_NUMBER
Composition:
Alert is entered.>
Definition:
#Details
DataType: NUMBER(6)
Describe: Number of an alert - currently alert numbers take on the current format CP[ordered number]-[four digit year]. They are currently entered by the Administrator. The system must now generate this number automaitcally.
Qualify: notnull
Physical: ALERT_NUMBER
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'ALERT_STATUS
Composition:
[NEW|UPDATE|CLOSED]
Definition:
#Details
DataType: VARCHAR2(10)
Describe: Status of an alert - it is either NEW, UPDATE, or CLOSED, these are hidden text fields on the input forms for XRX_NEW_ALERT, XRX_UPDATE_ALERT, and XRX_CLOSED_ALERT.
Qualify: notnull
Default: NEW
Physical: ALERT_STATUS
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'DATE_OPENED
Composition:
Definition:
#Details
DataType: DATE
Describe: Date alert was opened - auto filed when selection is made text box or on onload.
Qualify: notnull
Physical: DATE_OPENED
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'EMAIL
Composition:
Definition:
#Details
DataType: VARCHAR2(80)
Describe: Email of originator - this info should be loaded from Security System. Once they have logged into the single sign-on application.
Physical: EMAIL
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'FAX_NUMBER
Composition:
Definition:
#Details
DataType: VARCHAR2(20)
Describe: Fax number of the originator - web templete optional entry. Field length is set up to handle international phone numbers.
Physical: FAX_NUMBER
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'FIELD_OFFICE
Composition:
Definition:
#Details
DataType: VARCHAR2(15)
Describe: Field office of originator.
Physical: FIELD_OFFICE
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'MANAGER_APPROVAL
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What manager (field or home) NA_CA approved this Alert.
Qualify: notnull
Physical: MANAGER_APPROVAL
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'NA_ID
Composition:
Definition:
#Details
DataType: NUMBER
Describe: This is the auto serial number [sequence] for the tuple.
Qualify: notnull
Physical: NA_ID
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'ORIGINATED_BY
Composition:
Definition:
#Details
DataType: VARCHAR2(25)
Describe: Name of Alert Origniator - this info should be auto loaded from Security System. Once they have logged into the single sign-on application.
Qualify: notnull
Physical: ORIGINATED_BY
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'PHONE_NUMBER
Composition:
Definition:
#Details
DataType: VARCHAR2(20)
Describe: Phone number of the originator. Field length is set up to handle international phone numbers.
Physical: PHONE_NUMBER
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'PRIORITY_IMPACT
Composition:
[Will-Effect-Sales|Will-Effect-Marketing|Will-Effect-Customer-Relations] +
[Will-Cause-a-Lawsuit|Could-Effect-Sales|Could-Effect-Marketing] +
[Could-Effect-Customer-Relations|Could-Cause-a-Lawsuit]
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This attribute is used to describe the impact of the ALERT. Priority Impact is made of 8 menu items which are discribed in the Dictionary as MENU items.
Qualify: notnull
Physical: PRIORITY_IMPACT
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'PROBLEM_DESCRIPTION
Composition:
Definition:
#Details
DataType: VARCHAR2(2000)
Describe: The originator tells the factory what is wrong with the printer/product - this field is a web templet text area box.
Qualify: notnull
Physical: PROBLEM_DESCRIPTION
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'REGION
Composition:
[Canada|Eastern-Europe|Europe] +
[Latin-America|Japan|Pacific-Rim] +
[Northeast-US|Southeast-US|West-US]
Definition:
#Details
DataType: VARCHAR2(20)
Describe: Region is made up of 9 areas around the world. Region NA_CA 9 menu items which are discribed in the Dictionary as MENU items
Qualify: notnull
Physical: REGION
##
References:
ATTRIBUTE

Name: XRX_NEW_ALERT'WHAT_HAVE_YOU_DONE
Composition:
Definition:
#Details
DataType: VARCHAR2(2000)
Describe: The originator tells the factory what they have done to the printer/product - this field is a web templet text area box.
Qualify: notnull
Physical: WHAT_HAVE_YOU_DONE
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO
Composition:
*XRX_PRODUCT_INFO'PI_ID +
@XRX_PRODUCT_INFO'ALERT_NUMBER +
XRX_PRODUCT_INFO'PRODUCT_MODEL +
XRX_PRODUCT_INFO'SERIAL_NUMBER +
XRX_PRODUCT_INFO'NUMBER_OF_IP_COPIES +
XRX_PRODUCT_INFO'NUMBER_OF_COPIES +
XRX_PRODUCT_INFO'TONER_IMAGE_COUNT +
XRX_PRODUCT_INFO'CIK_IMAGE_COUNT +
XRX_PRODUCT_INFO'FUSER_IMAGE_COUNT +
XRX_PRODUCT_INFO'SECND_BT_IMAGE_COUNT +
XRX_PRODUCT_INFO'IMAGE_PROCESSOR_FV +
XRX_PRODUCT_INFO'INPUT_MAINS +
XRX_PRODUCT_INFO'PH_OTHER_PEC +
XRX_PRODUCT_INFO'PH_OTHER_PEEC1 +
XRX_PRODUCT_INFO'PH_OTHER_PEEC2 +
XRX_PRODUCT_INFO'PH_OTHER_PEEC3 +
XRX_PRODUCT_INFO'PH_OTHER_PEEC4 +
XRX_PRODUCT_INFO'COLOR_STIX_COUNT +
XRX_PRODUCT_INFO'MEMORY_AMT +
XRX_PRODUCT_INFO'OPTIONS +
XRX_PRODUCT_INFO'COMM_PORT +
XRX_PRODUCT_INFO'TYPE_NETWORK_CARD +
XRX_PRODUCT_INFO'NETWORK_CARD_SETUP +
XRX_PRODUCT_INFO'PRINT_MODE +
XRX_PRODUCT_INFO'FIRMWARE_VERSION +
XRX_PRODUCT_INFO'COLOR_CORRECTION
Definition:


Product Infon
References:
ERD(ENTITY) "AlertSystem.erd" "Main"

Name: XRX_PRODUCT_INFO'ALERT_NUMBER
Composition:
Alert is entered. This is also identified as a FK>
Definition:
#Details
DataType: NUMBER(6)
Describe: Number of an alert - currently alert numbers take on the current format CP[ordered number]-[four digit year]. They are currently entered by the Administrator. The system must now generate this number automaitcally.
Qualify: notnull
Physical: ALERT_NUMBER
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'CIK_IMAGE_COUNT
Composition:
Definition:
#Details
DataType: NUMBER
Describe: What is the CIK (Photocondive) Image Count (This applies to Laser printers).
Physical: CIK_IMAGE_COUNT
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'COLOR_CORRECTION
Composition:
[N-A|None|Vivid-Color|Display|SWOP|Euroscale|Commercial|Monochorme|Other...]
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the printer color correction set to - this field on the web templete is filled from a drop down list recieved from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: COLOR_CORRECTION
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'COLOR_STIX_COUNT
Composition:
Definition:
#Details
DataType: NUMBER
Describe: What is the color stix count (This applies to Phaser 600 ONLY).
Physical: COLOR_STIX_COUNT
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'COMM_PORT
Composition:
[N-A|Serial|LocalTalk|EtherNet|EtherTalk|Parallel|SCSI|FireWire|USB|Other...]
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the Communication Port the printer or Product is using - this field on the web templet is filled from a drop down list recieved from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: COMM_PORT
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'FIRMWARE_VERSION
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the print engine board firmware version - this field is a web templete text box.
Physical: FIRMWARE_VERSION
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'FUSER_IMAGE_COUNT
Composition:
Definition:
#Details
DataType: NUMBER
Describe: What is the fuser image count (This applies to Laser printers).
Physical: FUSER_IMAGE_COUNT
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'IMAGE_PROCESSOR_FV
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the image processor firmware version.
Physical: IMAGE_PROCESSOR_FV
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'INPUT_MAINS
Composition:
[N-A|100VAC-60Hz|110-120VAC-60Hz|220-240VAC-50Hz|Other...]
Definition:
#Details
DataType: VARCHAR2(10)
Describe: What is the imput mains be used (100, 110, 240, etc.) - this field on the web templet is filled from a drop down list recieved from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: INPUT_MAINS
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'MEMORY_AMT
Composition:
[N-A|4|8|16|32|64|128|256|512|1024|Other...]
Definition:
#Details
DataType: NUMBER
Describe: Hom much memory is installed in the printer - this field on the web templet is filled from a drop down list received from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: MEMORY_AMT
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'NETWORK_CARD_SETUP
Composition:
[N-A|EtherTalk|NetWare|TCP-IP|AppleTalk|Serial|Other...]
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the Network Card Setup - this field on the web templete is filled from a drop down list recieved from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: NETWORK_CARD_SETUP
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'NUMBER_OF_COPIES
Composition:
Definition:
#Details
DataType: NUMBER
Describe: How many print engine copies have been produced on this printer - this field is a web templete text box.
Physical: NUMBER_OF_COPIES
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'NUMBER_OF_IP_COPIES
Composition:
Definition:
#Details
DataType: NUMBER
Describe: What is the number of printer IP (image processor) copies.
Physical: NUMBER_OF_IP_COPIES
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'OPTIONS
Composition:
Definition:
#Details
DataType: VARCHAR2(100)
Describe: List the options that are part of the printer and/or product.
Physical: OPTIONS
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'PH_OTHER_PEC
Composition:
Definition:
#Details
DataType: VARCHAR2(20)
Describe: What is the Post Error Code (current). This is first error code in the stack.
Physical: PH_OTHER_PEC
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'PH_OTHER_PEEC1
Composition:
Definition:
#Details
DataType: VARCHAR2(20)
Describe: What is the Post Error History Code One (This applies to Laser printers).
Physical: PH_OTHER_PEEC1
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'PH_OTHER_PEEC2
Composition:
Definition:
#Details
DataType: VARCHAR2(20)
Describe: What is the Post Error History Code Two (This applies to Laser printers).
Physical: PH_OTHER_PEEC2
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'PH_OTHER_PEEC3
Composition:
Definition:
#Details
DataType: VARCHAR2(20)
Describe: What is the Post Error History Code Three (This applies to Laser printers).
Physical: PH_OTHER_PEEC3
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'PH_OTHER_PEEC4
Composition:
Definition:
#Details
DataType: VARCHAR2(20)
Describe: What is the Post Error History Code Four (This applies to Laser printers).
Physical: PH_OTHER_PEEC4
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'PI_ID
Composition:
Definition:
#Details
DataType: NUMBER
Describe: This is the auto serial number [sequence] for the tuple.
Qualify: notnull
Physical: PI_ID
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'PRINT_MODE
Composition:
[N-A|Persentation|Fast|Enhanced|Premium|300dpi|600x300dpi|Fast-Color] +
[Enhanced-Z350|Other...]
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What is the print quality mode the pringer is using - this field on the web templet is filled from a drop down list received form XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: PRINT_MODE
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'PRODUCT_MODEL
Composition:
[N-A|Phaser-I|Phaser-II|Phaser-II-SD-SDX|Phaser-III|Phaser-III-RX|Phaser-140] +
[Phaser-200i-e|Phaser-220i-e|Phaser-240|Phaser-300i|Phaser-300x|Phaser-340-350] +
[Phaser-360|Phaser-380|Phaser-440|Phaser-450|Phaser-480|Phaser-480X] +
[Phaser-540|Phaser-540P|Phaser-560|Phaser-600|Phaser-740|Phaser-750] +
[Phaser-780|Phaser-790|Phaser-840|Phaser-850|Phaser-860]
Definition:
#Details
DataType: VARCHAR2(25)
Describe: Printer/Product model, i.e., Phaser 1235 - this field on the web templet is filled from a drop down list received from the XRX_LOOKUP_TYPES and XRX_LOOKUP_CODES.
Qualify: notnull
Physical: PRODUCT_MODEL
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'SECND_BT_IMAGE_COUNT
Composition:
Definition:
#Details
DataType: NUMBER
Describe: What is the second transfer image count (This applies to Laser printers).
Physical: SECND_BT_IMAGE_COUNT
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'SERIAL_NUMBER
Composition:
Definition:
#Details
DataType: VARCHAR2(25)
Describe: Serial number of the product model.
Qualify: notnull
Physical: SERIAL_NUMBER
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'TONER_IMAGE_COUNT
Composition:
Definition:
#Details
DataType: NUMBER
Describe: What is the toner image count (This applies to Laser printers).
Physical: TONER_IMAGE_COUNT
##
References:
ATTRIBUTE

Name: XRX_PRODUCT_INFO'TYPE_NETWORK_CARD
Composition:
[N-A|SIMM-Style|DIMM-Style|Slide-In|Part-Of-IP_Bd|Other...]
Definition:
#Details
DataType: VARCHAR2(30)
Describe: What type of Network Card is the printer/product using - this field on the web templete is filled from a drop down list recieved from XRX_LOOKUP_CODES in the XXW_ALRT SCHEMA.
Physical: TYPE_NETWORK_CARD
##
References:
ATTRIBUTE

Name: XRX_UPDATE_ALERT
Composition:
*XRX_UPDATE_ALERT'UA_ID +
@XRX_UPDATE_ALERT'ALERT_NUMBER +
XRX_UPDATE_ALERT'ALERT_STATUS +
XRX_UPDATE_ALERT'UPDATE_DATE +
XRX_UPDATE_ALERT'UPDATED_BY +
XRX_UPDATE_ALERT'WEEKLY_STATUS_REP +
XRX_UPDATE_ALERT'DAYS_OPENED +
XRX_UPDATE_ALERT'FACTORY_FOCAL_POINT
Definition:


Update Alert Infoe
References:
ERD(ENTITY) "AlertSystem.erd" "Main"

Name: XRX_UPDATE_ALERT'ALERT_NUMBER
Composition:
Alert is entered. This is also identified as a FK>
Definition:
#Details
DataType: NUMBER(6)
Describe: Number of an alert - currently alert numbers take on the current format CP[ordered number]-[four digit year]. They are currently entered by the Administrator. The system must now generate this number automaitcally.
Qualify: notnull
Physical: ALERT_NUMBER
##
References:
ATTRIBUTE

Name: XRX_UPDATE_ALERT'ALERT_STATUS
Composition:
[NEW|UPDATE|CLOSED]
Definition:
#Details
DataType: VARCHAR2(10)
Describe: Status of an alert - it is either NEW, UPDATE, or CLOSED, these are hidden text fields on the ColdFusion forms.
Qualify: notnull
Physical: ALERT_STATUS
##
References:
ATTRIBUTE

Name: XRX_UPDATE_ALERT'DAYS_OPENED
Composition:
Definition:
#Details
DataType: NUMBER
Describe: This is a calculation done by the database per method/function. The calculation is done from the date the Alert was opened to the date that the alert was updated.
Qualify: notnull
Physical: DAYS_OPENED
##
References:
ATTRIBUTE

Name: XRX_UPDATE_ALERT'FACTORY_FOCAL_POINT
Composition:
[Focal-Point-Names-ST|Focal-Point-Names-ED]
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the person at the factory that will be responsible for the Alert during analysis to the point of fixing the problem or replacing the product. Names will appear in a dynamic dropdown menu from the XRX_LOOKUP_CODES.
Physical: FACTORY_FOCAL_POINT
##
References:
ATTRIBUTE

Name: XRX_UPDATE_ALERT'UA_ID
Composition:
Definition:
#Details
DataType: NUMBER
Describe: his is the auto serial number [sequence] for the tuple.
Qualify: notnull
Physical: UA_ID
##
References:
ATTRIBUTE

Name: XRX_UPDATE_ALERT'UPDATED_BY
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: Name of Alert updator - this info should be auto loaded from Security System, once thay have logged into the single sign-on application.
Qualify: notnull
Physical: UPDATED_BY
##
References:
ATTRIBUTE

Name: XRX_UPDATE_ALERT'UPDATE_DATE
Composition:
Definition:
#Details
DataType: DATE
Describe: What is the alert update date - auto filed when selection is made in text box or on onload. The date come from SYSDATE.
Qualify: notnull
Physical: UPDATE_DATE
##
References:
ATTRIBUTE

Name: XRX_UPDATE_ALERT'WEEKLY_STATUS_REP
Composition:
Definition:
#Details
DataType: VARCHAR2(2000)
Describe: What is the Weekly Status report for this Alert -- This is a textArea box on the web ColdFusion templet.
Qualify: notnull
Physical: WEEKLY_STATUS_REP
##
References:
ATTRIBUTE


Back to Top

Back | Home | Top | Feedback | Site Search


E-Mail Me

This site is brought to you by
Bob Betterton; 2001 - 2011.

This page was last updated on 02/08/2004
Copyright, RDB Prime Engineering



This Page has been accessed " 2548" times.