Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:C_FName
data Table name:Customer
data Type:Text
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The customer first name.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:C_LName
data Table name:Customer
data Type:Text
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The customer last name.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:C_Address
data Table name:Customer
data Type:Text
Data Length:255
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The customer address.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:C_DOB
data Table name:Customer
data Type:Date/Time
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The customer date of birth.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:C_Company
data Table name:Customer
data Type:Text
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The customer employer company name.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:C_Work_Phone
data Table name:Customer
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The customer work phone number.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:C_Mobile_Phone
data Table name:Customer
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The customer mobile phone number.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:C_Emer_Contact_Name
data Table name:Customer
data Type:Text
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The customer emergency contact name.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:C_Emer_Contact_Phone
data Table name:Customer
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The customer emergency contact phone number.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:Customer_ID
data Table name:Customer
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:Yes
data Default Value: No Default Value
Comments: The customer system id number.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:Flight_ID
data Table name:Customer
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:Yes
data Default Value: No Default Value
Comments: The customer flight id number.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:F_Start_City
data Table name:Flight
data Type:Text
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The city of origin for the requested flight.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:F_End_City
data Table name:Flight
data Type:Text
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The city of destination for the requested flight.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:F_Date
data Table name:Flight
data Type:Date/Time
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The date of travel for requested flight.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:F_Time
data Table name:Flight
data Type:Date/Time
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The time of travel for requested flight.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:F_Num_Customers
data Table name:Flight
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: Thenumber of passengers for requested flight.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:Flight_ID
data Table name:Flight
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:Yes
data Default Value: No Default Value
Comments: The customer flight id number.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:User_ID
data Table name:Flight
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The userid number.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:Payment_ID
data Table name:Invoice
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The payment id number.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:Flight_ID
data Table name:Invoice
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The flight id number.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:P_Amount
data Table name:Invoice
data Type:Currency
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:Yes
data Default Value: No Default Value
Comments: The charged flight booking amount.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:I_Booking_Date
data Table name:Invoice
data Type:Date/Time
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The date the flight was booked.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:Invoice_ID
data Table name:Invoice
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:Yes
data Default Value: No Default Value
Comments: The invoice id number.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:CC_FName
data Table name:Payment
data Type:Text
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The first name on the payment credit card.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:CC_LName
data Table name:Payment
data Type:Text
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The last name on the payment credit card.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:CC_Address
data Table name:Payment
data Type:Text
Data Length:255
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The address listed for the payment credit card.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:CC_Number
data Table name:Payment
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The account number of the payment credit card.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:CC_Exp_Date
data Table name:Payment
data Type:Date/Time
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The account number of the payment credit card.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:CC_Type
data Table name:Payment
data Type:Text
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The type of payment credit card.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:Flight_ID
data Table name:Payment
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:No
data Default Value: No Default Value
Comments: The flight id number.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:Payment_ID
data Table name:Payment
data Type:Number
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:Yes
data Default Value: No Default Value
Comments: The payment id number.
Data Dictionary Form: Data Element
System:BCA Business Management System
Field Name:P_Amount
data Table name:Payment
data Type:Currency
Data Length:50
Acceptable data Values:Alphanumeric Characters
data Required:Yes
data Default Value: No Default Value
Comments: The charged flight booking amount.