KFS data is retrieved using the FinancialWebAPI and transmitted to the Page-Up site.
| 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 | java field | Page-Up field |
|---|---|---|
| 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 |
Summary
- 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.
...
- (ex. UC2925000).
- Name will be the account number followed by a dash(-) followed by the name.
...
- Send to PageUp, six files with Account and name separated by the pipe(|) delimiter. The six files are duplicates of each other, five are account files and one is the cost center file. The first record on each file is a header record with the titles of the fields.
...
Another copy is also sent for the cost center import.
...
Link to Page-up site
| https://uconn.dc4.pageuppeople.com/dashboard? | use netid and password to authenticate |
Names of the output files
| uconn_configs/webapi/rpm/batch |
|---|
| 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 output data
...
Account|Name
9049092|9049092-Mcmahon Dining Hall
...
9049102|9049102-Gift Shop Change Fun
Execution Command
...
| /createAccountFileJob.html |
Control-M Schedule and Job
| Schedule | Job |
|---|
...
| UAT |
...
| UAT_AEWEB_SCHEDULE |
...
| UAT_RPM_ACCOUNT_TO_PAGEUP | Ad-Hoc | |
| PRD |
...
| PRD_AEWEB_RPM_SCHEDULE1 |
...
| PRD_RPM_ACCOUNT_TO_PAGEUP1 | Runs daily at 6:45am |