Table 89. Body Detail Data Elements for the Default Account Enrollment Input File
|
|
|
|
|
Detail Record Type |
4 |
Num |
No |
A number indicating this is the detail record type. |
Action Type |
10 |
Varchar |
Yes |
The type of action. The values can be Register - Enrolling a user, Change - Changing account details, or Deregister - Deregistering a user. |
Action Description |
23 |
Varchar |
No |
A description of the action type. |
Sponsor ID |
32 |
Varchar |
No |
A unique ID for the sponsor, sent by the consolidator. |
Consolidator User ID |
32 |
Varchar |
No |
A unique ID for the service user, sent by the consolidator. |
Biller User ID |
32 |
Varchar |
No |
A unique ID for the service user, sent by the biller. |
Consolidator ID |
32 |
Varchar |
Yes |
The name of the consolidator. |
Consolidator Transaction ID |
32 |
Varchar |
No |
A unique transaction ID provided by the consolidator. |
Biller Transaction ID |
32 |
Varchar |
No |
A unique transaction ID provided by the biller. |
Biller ID |
32 |
Varchar |
Yes |
A unique ID for the biller, implementation-specific. |
Biller Name |
32 |
Varchar |
No |
The biller's name. |
Biller Address Line 1 |
32 |
Varchar |
No |
The biller's remittance address line 1. |
Biller Address Line 2 |
32 |
Varchar |
No |
The biller's remittance address line 2. |
Biller City |
32 |
Varchar |
No |
The biller's city. |
Biller State |
2 |
Varchar |
No |
The biller's state. |
Biller ZipCode |
5 |
Varchar |
No |
The biller's five-digit postal code. |
Biller Zip + 4 |
4 |
Varchar |
No |
The biller's four-digit postal code extension. |
Billing System ID |
32 |
Varchar |
No |
The billing system ID used in combination with account number to uniquely identify an account. |
Account Number |
32 |
Varchar |
Yes |
The user's account number. |
New Account Number |
32 |
Varchar |
No |
The new user account number, populated only for requests to change the account number. |
Bill Processing Center ID |
9 |
Varchar |
No |
The ID of the bill processing center that processes bills for this account. This maps to the Biller ID column in Oracle Billing Insight used to identify the billing system. |
User Type |
1 |
Char |
No |
The type of user: I- Individual or B- Business Retail. |
Business Name |
40 |
Varchar |
No |
The name of the business as known to the biller, populated only if the user type is B- Business Retail. |
User Last Name |
32 |
Varchar |
No |
The user's last name. |
User First Name |
32 |
Varchar |
No |
The user's first name. |
User Middle Name |
32 |
Varchar |
No |
The user's middle name. |
User Email Address |
100 |
Varchar |
No |
The user's email ID. |
User Address Line 1 |
40 |
Varchar |
No |
Line one of the address where service is provided. |
User Address Line 2 |
40 |
Varchar |
No |
Line two of the address where service is provided. |
User Address Line 3 |
40 |
Varchar |
No |
Line three of the address where service is provided. |
User City |
32 |
Varchar |
No |
The user's city. |
User State |
2 |
Varchar |
No |
The user's state. |
User Zip 5 |
5 |
Varchar |
No |
The user's five-digit postal code. |
User Zip 4 |
4 |
Varchar |
No |
The user's four-digit postal code extension. |
User Zip 2 |
2 |
Varchar |
No |
The user's two-digit postal code extension. |
User Country Code |
3 |
Varchar |
No |
The user's country code. |
User Postal Code |
11 |
Varchar |
No |
The user's postal code. |
User Province Name |
30 |
Varchar |
No |
The user's province. |
User Day Phone Number |
32 |
Varchar |
No |
The user's day phone number. |
User Evening Phone Number |
32 |
Varchar |
No |
The user's evening phone number. |
Bill Payment Activated |
1 |
Char |
No |
Indicates whether the bill payment service is activated, typically Y or N. |
Service Verification Field 1 |
32 |
Varchar |
No |
First field used by the biller to verify service activation. |
Service Verification Field 2 |
32 |
Varchar |
No |
Second field used by the biller to verify service activation. |
Service Verification Field 3 |
32 |
Varchar |
No |
Third field used by the biller to verify service activation. |
Service Verification Field 4 |
32 |
Varchar |
No |
Fourth field used by the biller to verify service activation. |
Service Verification Field 5 |
32 |
Varchar |
No |
Fifth field used by the biller to verify service activation. |
Service Verification Field 6 |
32 |
Varchar |
No |
Sixth field used by the biller to verify service activation. |
Alternate Biller Account Number |
32 |
Varchar |
Yes |
The user's internal account number as maintained by the biller. This can be the same as the User Account Number. |
New Alternate Biller Account Number |
32 |
Varchar |
No |
The new internal account number provided in case the existing internal account number is changed. Used only when the Action Type is Change. |
Server Transaction Timestamp |
20 |
Varchar |
No |
The time stamp assigned to the original service activation request. |
Auto Activation Flag |
1 |
Char |
No |
Identifies whether the subscriber's account was activated through a sponsor-initiated marketing program that did not require the explicit approval of the subscriber. The value is A if the account was auto-activated or S if the account was self-activated by subscriber. |
Paper Question Status |
1 |
Char |
No |
The state of the attempt to get the subscriber to agree to paper suppression. |
Paper Status Code |
1 |
Char |
No |
Indicates the state of paper bill or E-bill delivery. |
Paper Suppression Date |
20 |
Date Time |
No |
The date when paper suppression starts. |
Incentive Message ID |
4 |
Varchar |
No |
The identifier of the incentive message currently active for the account. If the biller does not support incentive messages, then this field contains zeroes. |
Bill Remittance Account Number |
32 |
Varchar |
No |
The account number to which any remittance transactions from the biller are made. If this is blank, then remittance is made to the account number |
Consolidator Enrollment Status |
1 |
Char |
No |
The status of the consolidator's enrollment. The default value is blank. |
Biller Enrollment Status |
1 |
Char |
No |
The status of the biller's enrollment. The default value is blank. |
Deactivation Source |
1 |
Char |
No |
Identifies whether the account was deactivated as a result of subscriber action or because the trial period ended. |
E-Bill Start Date |
20 |
Date Time |
No |
The date when next the next E-Bill can be expected |
Response Code |
1 |
Char |
No |
The response to the service activation request sent to the biller by the consolidator. Typical values are A and R. |
Rejected Text |
255 |
Varchar |
No |
If a service activation request is rejected, then this field has the rejection reasons. |
Status Code |
5 |
Varchar |
No |
The Success or Failure status code. |
Status Message |
80 |
Varchar |
No |
The description of the failure codes. |
Custom Field 1 |
255 |
Varchar |
No |
For future use. |
Custom Field 2 |
255 |
Varchar |
No |
For future use. |
Custom Field 3 |
255 |
Varchar |
No |
For future use. |
Custom Field 4 |
255 |
Varchar |
No |
For future use. |
Custom Field 5 |
1024 |
Varchar |
No |
For future use. |
Custom Field 6 |
1 |
Char |
No |
For future use. |
Custom Field 7 |
1 |
Char |
No |
For future use. |
Custom Field 8 |
20 |
Date Time |
No |
For future use. |
Custom Field 9 |
20 |
Date Time |
No |
For future use. |
