...
ACCT_CLOSED_IND accountClosed
CA_SUB_FUND_GRP_T
SUB_FUND_GRP_CD subfund
FUND_GRP_CD fundGroup
SUB_FUND_GRP_DESC description
SUBFUNDGRP_ACTV_CD activeCode
SUB_FUNDGRP_TYP_CD groupTypeCode
FIN_REPORT_SORT_CD reportSortCode
SUB_FUND_GRP_WAGE_IND wageIndicator
FND_GRP_BA_RSTR_LVL_CD budgetAdjustmentRestrictionCode
ACCT_RSTRC_STAT_CD accountRestrictedStatusCode
Using the subFundGroupCode from the active Account record, select the active records from the SubFund Group Table. Choose those accounts that have the wage indicator set to ‘Y’. These are known as payroll accounts.
The AccountId is chart followed by account.Select all active accounts.
Send to PageUp, five files with Account and name separated by the pipe(|) delimiter.
...