CRANALYST FILE

                           AR Credit Analysts

AR Credit Analysts

REFERENCED BY

AR01.1    AR08.1    AR105     AR110     AR115     AR140
AR206     AR210     AR217     AR234     AR235     AR251
AR253     AR260     AR271     AR274     AR275     AR282
AR290     AR292     AR70.1    AR70.2    AR74.1    AR973

UPDATED BY

AR06.1    AR10.1    AR501     AR550     BL02.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CAN-COMPANY          Numeric 4                                   AR06.1
Company              Company number.

CAN-CREDIT-ANLYST    Alpha 4                                     AR06.1
Credit Analyst       Credit Analyst. Code or identifier of a
                     credit analyst or definition of
                     responsibility that will be assigned to
                     a customer.

CAN-NAME             Alpha 30  (Lower Case)                      AR06.1
Credit Analyst Name  The name/description of the credit
                     responsibility.

CAN-PHONE-NMBR       Alpha 15                                    AR06.1
Telephone Number     Credit analyst's telephone number.

CAN-PHONE-EXT        Alpha 5                                     AR06.1
Telephone Extension  Telephone extension number.

CAN-USED-FL          Alpha 1                                     AR06.1  AR10.1
Used                 This field indicates whether or not         AR501   AR550
                     this credit analyst has been used,          BL02.1
                     (assigned to a customer). Valid values
                     are:

                     N = No
                     Y = Yes

                         CRANALYST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CANSET1   COMPANY       This path is used for record uniqueness  AR01.1  AR06.1
          CREDIT-ANLYST and selection.                           AR08.1  AR10.1
                                                                 AR105   AR110
                                                                 AR115   AR140
                                                                 AR206   AR210
                                                                 AR217   AR234
                                                                 AR235   AR251
                                                                 AR253   AR260
                                                                 AR271   AR274
                                                                 AR275   AR282
                                                                 AR290   AR292
                                                                 AR501   AR550
                                                                 AR70.1  AR70.2
                                                                 AR74.1  AR973
                                                                 BL02.1

                         CRANALYST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            CAN-COMPANY          -> ACO-COMPANY

                         CRANALYST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Creditsel      ARCDSELECT   Delete Cascades

                            CAN-COMPANY          -> SEL-COMPANY
                            CAN-CREDIT-ANLYST    -> SEL-CREDIT-ANLYST
                                                    SEL-DATE
                                                    SEL-SYS-TIME
                                                    SEL-CUSTOMER
                                                    SEL-SELECT-LEVEL