The document tag values in the table below have been added for the Expenses section of the Admin Report and associated to the PDF Process Type of ADMREP EXPENSES:
|
Field Tag |
Description |
System Value |
|
FEES PAID01 |
Month |
Each month in the reporting period less 12 months. |
|
FEES PAID02 |
Payroll |
The sum of the Actual Earnings record amounts with a Type of BASIC effective for the month for each active Membership for the month. |
|
FEES PAID03 |
Rate |
The applicable rate for the Income or Expense Rule effective for the month for each month and Global Type, except where there is more than one Income or Expense Rule for the same Global Type effective for the month for different Membership Groups. |
|
FEES PAID04 |
Due |
The Business Transactions (BT”s) with a Transaction Date greater than or equal to the first day of the month and less than or equal to the last day of the month in the FEESPAYABLE account for each month in the period from the report To Date less 12 months and the report To Date or from the report From Date to the report To Date if this period is greater than 12 months and per Global Type where the Accounting Activity is SFNOFEEO, FEEPBLREV, FEEBILLING, FEEBILLINGRE, FEEBILLINGREVE or FEEPBLREVE. |
|
FEES PAID05 |
Paid |
The Business Transactions (BT”s) with a Transaction Date greater than or equal to the first day of the month and less than or equal to the last day of the month in the FEESPAYABLE account for each month in the period from the report To Date less 12 months and the report To Date or from the report From Date to the report To Date if this period is greater than 12 months and per Global Type where the Accounting Activity is FEEPAYABLE-A, FEEPAYBLAL-R, FEESPAID or FEESPAIDREV. |
|
FEES PAID06 |
Difference |
FEES PAID04 - FEES PAID05. |
|
FEES PAID07 |
Date Paid |
The Transaction Date of the latest Paid BT (FEES PAID05). |
|
PREMIUMS PAID01 |
Group Life Premiums Month |
Each month in the reporting period less 12 months. |
|
PREMIUMS PAID02 |
Group Life Premiums Payroll |
The sum of the Actual Earnings record amounts with a Type of BASIC effective for the month for each active Membership for the month. |
|
PREMIUMS PAID03 |
Group Life Premiums Rate |
The applicable rate for the Income or Expense Rule effective for the month for each month and Global Type, except where there is more than one Income or Expense Rule for the same Global Type effective for the month for different Membership Groups do not extract the rate. |
|
PREMIUMS PAID04 |
Group Life Premiums Due |
The BT’s with a Transaction Date greater than or equal to the first day of the month and less than or equal to the last day of the month in the PREMPAYABLE account for each month in the period from the report To Date less 12 months and the report To Date, or from the report From Date to the report To Date if this period is greater than 12 months and per Global Type, where the Accounting Activity is SFNOPRMO, PREMBILLING or PREMBILLINGR. |
|
PREMIUMS PAID05 |
Group Life Premiums Paid |
The BT’s with a Transaction Date greater than or equal to the first day of the month and less than or equal to the last day of the month in the PREMPAYABLE account for each month in the period from the report To Date less 12 months and the report To Date, or from the report From Date to the report To Date if this period is greater than 12 months and per Global Type, where the Accounting Activity is PREMPAYABLE-A, PREMPAYBAL-R, PREMIUMPAID, PREMPAIDREV, PREMPAIDCOR or PREMPAIDREVE. |
|
PREMIUMS PAID06 |
Group Life Premiums Difference |
PREMIUMS PAID04- PREMIUMS PAID05. |
|
PREMIUMS PAID07 |
Group Life Premiums Date Paid |
The Transaction Date of the latest Paid BT (PREMIUMS PAID05). |
|
PREMIUMS PAID08 |
Disability Income Premiums Month |
Each month in the reporting period less 12 months. |
|
PREMIUMS PAID09 |
Disability Income Premiums Payroll |
The sum of the Actual Earnings record amounts with a Type of BASIC effective for the month for each active Membership for the month. |
|
PREMIUMS PAID10 |
Disability Income Premiums Rate |
The applicable rate for the Income or Expense Rule effective for the month for each month and Global Type, except where there is more than one Income or Expense Rule for the same Global Type effective for the month for different Membership Groups do not extract the rate. |
|
PREMIUMS PAID11 |
Disability Income Premiums Due |
The BT’s with a Transaction Date greater than or equal to the first day of the month and less than or equal to the last day of the month in the PREMPAYABLE account for each month in the period from the report To Date less 12 months and the report To Date, or from the report From Date to the report To Date if this period is greater than 12 months and per Global Type. |
|
PREMIUMS PAID12 |
Disability Income Premiums Paid |
The BT’s with a Transaction Date greater than or equal to the first day of the month and less than or equal to the last day of the month in the PREMPAYABLE account for each month in the period from the report To Date less 12 months and the report To Date, or from the report From Date to the report To Date if this period is greater than 12 months and per Global Type. |
|
PREMIUMS PAID13 |
Disability Income Premiums Difference |
PREMIUMS PAID11- PREMIUMS PAID12. |
|
PREMIUMS PAID14 |
Disability Income Premiums Date Paid |
The Transaction Date of the latest Paid BT (PREMIUMS PAID12). |
|
PREMIUMS PAID15 |
Spouse Cover Premiums Month |
Each month in the reporting period less 12 months. |
|
PREMIUMS PAID16 |
Spouse Cover Premiums Payroll |
The sum of the Actual Earnings record amounts with a Type of BASIC effective for the month for each active Membership for the month. |
|
PREMIUMS PAID17 |
Spouse Cover Premiums Rate |
The applicable rate for the Income or Expense Rule effective for the month for each month and Global Type, except where there is more than one Income or Expense Rule for the same Global Type effective for the month for different Membership Groups do not extract the rate. |
|
PREMIUMS PAID18 |
Spouse Cover Premiums Due |
The BT’s with a Transaction Date greater than or equal to the first day of the month and less than or equal to the last day of the month in the PREMPAYABLE account for each month in the period from the report To Date less 12 months and the report To Date, or from the report From Date to the report To Date if this period is greater than 12 months and per Global Type. |
|
PREMIUMS PAID19 |
Spouse Cover Premiums Paid |
The BT’s with a Transaction Date greater than or equal to the first day of the month and less than or equal to the last day of the month in the PREMPAYABLE account for each month in the period from the report To Date less 12 months and the report To Date, or from the report From Date to the report To Date if this period is greater than 12 months and per Global Type. |
|
PREMIUMS PAID20 |
Spouse Cover Premiums Difference |
PREMIUMS PAID18- PREMIUMS PAID19 |
|
PREMIUMS PAID21 |
Spouse Cover Premiums Date Paid |
The Transaction Date of the latest Paid BT (PREMIUMS PAID19). |
|
PREMIUMS PAID22 |
Funeral Premiums Month |
Each month in the reporting period less 12 months. |
|
PREMIUMS PAID23 |
Funeral Premiums Payroll |
The sum of the Actual Earnings record amounts with a Type of BASIC effective for the month for each active Membership for the month. |
|
PREMIUMS PAID24 |
Funeral Premiums Rate |
The applicable rate for the Income or Expense Rule effective for the month for each month and Global Type, except where there is more than one Income or Expense Rule for the same Global Type effective for the month for different Membership Groups do not extract the rate. |
|
PREMIUMS PAID25 |
Funeral Premiums Due |
The BT’s with a Transaction Date greater than or equal to the first day of the month and less than or equal to the last day of the month in the PREMPAYABLE account for each month in the period from the report To Date less 12 months and the report To Date, or from the report From Date to the report To Date if this period is greater than 12 months and per Global Type. |
|
PREMIUMS PAID26 |
Funeral Premiums Paid |
The BT’s with a Transaction Date greater than or equal to the first day of the month and less than or equal to the last day of the month in the PREMPAYABLE account for each month in the period from the report To Date less 12 months and the report To Date, or from the report From Date to the report To Date if this period is greater than 12 months and per Global Type. |
|
PREMIUMS PAID27 |
Funeral Premiums Difference |
PREMIUMS PAID25- PREMIUMS PAID26 |
|
PREMIUMS PAID28 |
Funeral Premiums Date Paid |
The Transaction Date of the latest Paid BT (P PREMIUMS PAID26). |
|
TAX PAID01 |
Month |
Each month in the reporting period less 12 months. |
|
TAX PAID02 |
Due |
The BT’s with a Transaction Date greater than or equal to the first day of the month and less than or equal to the last day of the month in the PAYEPAYABLE account for each month in the period from the report To Date less 12 months and the report To Date or from the report From Date to the report To Date if this period is greater than 12 months and per Global Type where the Accounting Activity is BENALPAYE, BENALPAYED or BENALPAYEREV. |
|
TAX PAID03 |
Paid |
The BT’s with a Transaction Date greater than or equal to the first day of the month and less than or equal to the last day of the month in the PAYEPAYABLE account for each month in the period from the report To Date less 12 months and the report To Date or from the report From Date to the report To Date if this period is greater than 12 months and per Global Type where the Accounting Activity is PAYPAYE, BENPAYEPAY-A, BENPAYEPALRE, BENPAYEPAYRE or BPAYEALLO-RE. |
|
TAX PAID04 |
Difference |
TAX PAID02 - TAX PAID03. |
|
TAX PAID05 |
Date Paid |
The Transaction Date of the latest Paid BT (TAX PAID03). |