KFS data is retrieved using the FinancialWebAPI.
CA-ACCOUNT_T java field Page-Up field
ACCOUNT_NBR account account, part of name
FIN_COA_CD chart
OBJ_ID objectId
VER_NBR versionNumber
ACCOUNT_NM name part of name
ORG_CD orgCode
ACCT_TYP_CD accountTypeCode
SUB_FUND_GRP_CD subFundGroupCode
ACCT_EXPIRATION_DT expirationDate
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
Account 9999999 - Special Payroll Account must appear on the files, regardless of other selection criteria.
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.
Bypass any expired accounts.
The AccountId is chart followed by account.
Send to PageUp, five files with Account and name separated by the pipe(|) delimiter.
Name will be the account number followed by a dash(-) followed by the name.
The five files are duplicates of each other. The first record is a header record with the titles of the fields.
Another copy is also sent for the cost center import.
Names of the files:
accounts-1-page-up.txt
accounts-2-page-up.txt
accounts-3-page-up.txt
accounts-4-page-up.txt
accounts-5-page-up.txt
cost-centers-page-up.txt
Sample data:
Account|Name
9049092|9049092-Mcmahon Dining Hall
9049093|9049093-Whitney Dining Hall
9049094|9049094-Putnam Refectory
9049095|9049095-North Campus Petty C
9049096|9049096-Transcript Change Fu
9049100|9049100-Car Rental Petty Cas
9049101|9049101-Cash Bank Revolving
9049102|9049102-Gift Shop Change Fun
Execution Command:
/createAccountFileJob.html
Control-M Schedule and Job:
UAT - UAT_AEWEB_SCHEDULE/UAT_RPM_ACCOUNT_TO_PAGEUP
PRD - PRD_AEWEB_RPM_SCHEDULE1/PRD_RPM_ACCOUNT_TO_PAGEUP1