Closed and Non-zero Status Cards Report (FPSDR168) |
  
|
Navigation: Deposit Reports > Deposit Reports - Numerical Order >
Closed and Non-zero Status Cards Report (FPSDR168) |
|
Availability
This report is generally run daily in the afterhours, but it can be processed for a specified number of days, e.g., seven days or once a week. It can only be processed once a day.
Purpose
The Closed and Non-zero Status Cards Report shows all important card data from the Card Management screen (function 45/46 in the CIF System) for cards that are closed on the run day and have a Card Status of 99 or 199. An option is available to add all other Card Status types (101-106) to this report, based on the last changed date (APCHON). If this date is within the specified dates on the report, and the Card Status is 101-106, the card information will be shown on the report. This means that a card may appear on the report even though the status was not changed, but because the last changed date was.
The sorting options are:
80 Office Number
81 Account Number
82 Household Number
83 Card Number
84 Primary Short Name
85 Product Code
86 Card Type
87 MTD Transactions
88 Card Status
|
GOLDPoint Systems Only: If Misc Opts 1=Y, then the Open to Buy Balance will be included on the report. It is a calculated field based on the “Heloc” card method.
If Misc Opts 2=Y, then the following Card Status codes will be included in the report:
101 Lost, capture card 102 Stolen, capture card 103 Hot, capture card 104 Fraud, capture card 105 Permanent restraint, capture card 106 Bad debt, capture card
The first 3 spaces in the Misc Parm field can be used to force the report to pull a certain number of days of closed cards. For example, if “7” is entered in one of the first 3 spaces of the Misc Parm field, then a week’s worth of closed cards will show on the report. |
|---|
Report Column Information
See FPSDR168 Example for an example of this report.
Column |
Description |
|---|---|
Card Nbr |
This is the card number derived from the ISO/ANSI number, the card sequence number, and a calculated check digit. |
Nbr Seq |
This is the card sequence number on this account. A household may have several different types of cards and each is distinguished by this number. |
Crd Stat |
This is the current status of the card taken from the CIF System. |
Iss Freq |
This is the frequency in months by which the expiration date should be advanced each time a card is issued. The default is 24 months (2 years). |
Crd Type |
This is the type of card. The following types are available: 01 ATM check guarantee card 02 ATM card only 03 Check guarantee card without PIN number 04 Debit card 05 Credit card |
Last Used |
This is the date the card was last used. |
Opnd/Clsd |
This shows the date the card was closed. |
Exp. Date |
This is the date the card will expire based on the Issue Freq and Date Card Last Issued fields on the Card Management screen (function 45/46) in the CIF System (Application 9). |
Fee $$ |
This is the amount charged for each card issued. |
Fee Cd |
This is the code for the fee above. |
Mtd Tran US – Frgn |
This is the month-to-date transactions for both on-us and foreign categories. The transactions that are updated are inquiries, deposits, withdrawals, transfers, purchases, and returns. |
Last Updated |
This is the date the card was last file maintained. For Card Status 101-106, this may or may not be when the card was closed. |
Household Number |
This is the household number for the account, pulled from the CIF System (MNHHLD). |
Primary: Account |
This is the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) of the primary account associated with this card. |
Secondary: Account |
This is the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) of the secondary account associated with this card. |
Prod |
This is the product code of the account associated with this card. |
Current Bal |
This is the current balance of the account associated with this card. This is taken from the Current Balance field on the Deposit Master Fields screen (function 1/2) if it is a deposit account. If it is tied to a loan, it will be the loan balance. |
Primary Name |
This is the primary name of the account associated with this card. |
(Secondary Name) |
This is the secondary name of the account associated with this card. |
Primary Address |
This is the primary address of the account associated with this card. |
Primary City/State/ZIP |
This is the conclusion of the primary address of the account associated with this card. |
Totals and Subtotals Provided
Totals and Subtotals are provided in the following categories:
1. Number of card records
2. Number of primary cards issued
3. Number of secondary cards issued
4. Month to Date on-us transactions
5. Month to Date on foreign transactions
6. Total Cards issued (2 + 3)
7. Total transactions (4 + 5)
