STANDARD DATA DICTIONARY #340.7 -- AR METRICS FILE 3/24/25 PAGE 1
STORED IN ^RCSTAT(340.7, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 4.5)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This file will store metrics data for all options within the Accounts Receivable package. The metrics data could be option
specific (such as # of Repayment Plans Administratively Closed) or technical (how long did it take the Repayment Plan Nightly
Process to run) in nature.
DD ACCESS: @
RD ACCESS: @
WR ACCESS: @
DEL ACCESS: @
LAYGO ACCESS: @
AUDIT ACCESS: @
CROSS
REFERENCED BY: DATE(B)
LAST MODIFIED: NOV 18,2023@18:59:12
340.7,.01 DATE 0;1 DATE (Required)
INPUT TRANSFORM: S %DT="EX" D ^%DT S X=Y K:Y<1 X
LAST EDITED: MAY 28, 2021
HELP-PROMPT: Enter the date the metrics were captured.
DESCRIPTION:
The date the statistics were captured.
CROSS-REFERENCE: 340.7^B
1)= S ^RCSTAT(340.7,"B",$E(X,1,30),DA)=""
2)= K ^RCSTAT(340.7,"B",$E(X,1,30),DA)
340.7,1.01 RPP NO. BILLS ADDED MANUALLY RPP;1 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: MAY 28, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION:
This field stores the number of times a bill was manually added to a Repayment Plan on a given day.
340.7,1.02 RPP NO. BILLS NP ADDED RPP;2 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: MAY 28, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of bills added to Repayment Plans by the Repayment Plan Nightly
Process.
340.7,1.03 RPP NO. PLANS INTO REVIEW RPP;3 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that were flagged for Review on a given day by
either the Repayment Plan Nightly Process or when bills were manually added to a Repayment Plan.
340.7,1.04 RPP NO. PLANS REMOVED REVIEW RPP;4 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: MAY 28, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that were removed from Review on a given day by
either the Repayment Plan Nightly Process or when the terms of the plan were edited.
340.7,1.05 RPP NO. PLANS NEW CS AUTO RPP;5 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: MAY 28, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of active Repayment Plans whose debtors had bills sent to the Treasury
Cross Servicing Program with the Repayment Plans AUTO ADD (automatically adding new bills to active
repayment plans) set to Yes.
340.7,1.06 RPP NO. PLANS NEW CS NO AUTO RPP;6 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: MAY 28, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of active Repayment Plans whose debtors had bills sent to the Treasury
Cross Servicing Program with the Repayment Plans AUTO ADD (automatically adding new bills to active
repayment plans) set to No.
340.7,1.07 RPP NO. PLANS CS ENTER RPP;7 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: MAY 28, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of new Repayment Plans created on a given date for debtors who have
debt referred to the Treasury Cross Servicing Program.
340.7,1.08 RPP NO. PLANS CS REMOVED RPP;8 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: MAY 28, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of active plans whose debtors with debt in the Treasury Cross
Servicing Program recalled all of that debt successfully.
340.7,1.09 RPP NO. FORBEARANCES GRANTED RPP;9 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: MAY 28, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION:
This fields stores the Number of Forbearances granted daily.
340.7,1.11 NO. PLANS NEW TO CURRENT RPP;10 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of New to a status of
Current.
340.7,1.12 NO. PLANS CURRENT TO LATE RPP;11 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Current to a
status of Late.
340.7,1.13 NO. PLANS LATE TO DELINQUENT RPP;12 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Late to a status
of Delinquent.
340.7,1.14 NO. PLANS DELINQ TO DEFAULT RPP;13 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Delinquent to a
status of Defaulted.
340.7,1.15 NO. PLANS DEFAULT TO TERM RPP;14 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Defaulted to a
status of Terminated.
340.7,1.16 NO. PLANS LATE TO CURRENT RPP;15 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Late to a status
of Current.
340.7,1.17 NO. PLANS DELINQUENT TO LATE RPP;16 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Delinquent to a
status of Late.
340.7,1.18 NO. PLANS DELINQ TO CURRENT RPP;17 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Delinquent to a
status of Current.
340.7,1.19 NO. PLANS DEFAULT TO DELINQ RPP;18 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Defaulted to a
status of Delinquent.
340.7,1.21 NO. PLANS DEFAULTED TO LATE RPP;19 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Defaulted to a
status of Late.
340.7,1.22 NO. PLANS DEFAULT TO CURRENT RPP;20 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Defaulted to a
status of Current.
340.7,1.23 NO. PLANS CURRENT TO PAID RPP;21 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Current to a
status of Paid In Full.
340.7,1.24 NO. PLANS LATE TO PAID RPP;22 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Late to a status
of Paid In Full.
340.7,1.25 NO. PLANS DELINQUENT TO PAID RPP;23 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Delinquent to a
status of Paid In Full.
340.7,1.26 NO. PLANS DEFAULTED TO PAID RPP;24 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: DEC 06, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Defaulted to a
status of Paid in Full.
340.7,1.27 NO. PLANS CLOSED ADMIN RPP;25 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have been Closed using the reason of
Administrative.
340.7,1.28 NO. PLANS CLOSED DEFAULT RPP;26 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 20, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have been manually Closed due to Debtor
Default.
340.7,1.29 NO. PLANS NEW TO CLOSED RPP;27 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of New to a status of
Closed.
340.7,1.31 NO. PLANS CURRENT TO CLOSED RPP;28 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Current to a
status of Closed.
340.7,1.32 NO. PLANS LATE TO CLOSED RPP;29 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Late to a status
of Closed.
340.7,1.33 NO. PLANS DELINQ TO CLOSED RPP;30 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: OCT 15, 2021
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of Delinquent to a
status of Closed.
340.7,1.34 NO. PLANS NEW TO PAID RPP;31 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: JAN 28, 2022
HELP-PROMPT: Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION: This field stores the number of Repayment Plans that have moved from a status of NEW to PAID IN
FULL.
340.7,1.35 NO. PLANS NEW RPP;32 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: JUL 07, 2023
HELP-PROMPT: Enter the number of new Repayment Plans. Type a number between 0 and 999999, 0 decimal digits.
DESCRIPTION:
This field stores the number of new Repayment Plans created.
340.7,2.01 NO. SECS AT CS PROCESSING RPPTECH;1 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: MAY 28, 2021
HELP-PROMPT: Enter the length of time, in seconds to run process.
DESCRIPTION: This field stores how long it took the AT CS review portion of the Repayment Plan Nightly Process
to run (in seconds).
340.7,2.02 NO. SECS RPP ADD BILLS RPPTECH;2 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: MAY 28, 2021
HELP-PROMPT: Enter the length of time, in seconds to run process.
DESCRIPTION: This field stores the length of time (in seconds) it took to complete the Add New Bills section of
the Repayment Plan Nightly Process.
340.7,2.03 NO. SECS RPP STATUS UPDATE RPPTECH;3 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: MAY 28, 2021
HELP-PROMPT: Enter the length of time, in seconds to run process.
DESCRIPTION: This field stores the length of time (in seconds) it took to complete the Repayment Plan Status
Update portion of the Repayment Plan Nightly Process.
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):