Data Dictionary Form: Data Element

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.