...
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
| 0 | kfsChartCode | KFS Chart Code | Yes | String (2) | 'IR' |
| 1 | kfsAcctNumber | KFS Account NumberOrg Code | Yes | String (74) | '12345671234' |
DB Query
| Code Block |
|---|
SELECT a.FIN_COA_CD
,a.ACCOUNT_NBR
,a.ACCOUNT_NM
,a.ACCT_FSC_OFC_UID
,a.ACCT_SPVSR_UNVL_ID
,a.ACCT_MGR_UNVL_ID
,a.ORG_CD
,a.ACCT_TYP_CD
,a.ACCT_PHYS_CMP_CD
,a.SUB_FUND_GRP_CD
,a.ACCT_FRNG_BNFT_CD
,a.FIN_HGH_ED_FUNC_CD
,a.ACCT_RSTRC_STAT_CD
,a.ACCT_RSTRC_STAT_DT
,a.ACCT_CITY_NM
,a.ACCT_STATE_CD
,a.ACCT_STREET_ADDR
,a.ACCT_ZIP_CD
,a.RPTS_TO_FIN_COA_CD
,a.RPTS_TO_ACCT_NBR
,a.ACCT_CREATE_DT
,a.ACCT_EFFECT_DT
,a.ACCT_EXPIRATION_DT
,a.CONT_FIN_COA_CD
,a.CONT_ACCOUNT_NBR
,a.ENDOW_FIN_COA_CD
,a.ENDOW_ACCOUNT_NBR
,a.CONTR_CTRL_FCOA_CD
,a.CONTR_CTRLACCT_NBR
,a.INCOME_FIN_COA_CD
,a.INCOME_ACCOUNT_NBR
,a.ACCT_ICR_TYP_CD
,a.AC_CSTM_ICREXCL_CD
,a.FIN_SERIES_ID
,a.ICR_FIN_COA_CD
,a.ICR_ACCOUNT_NBR
,a.ACCT_IN_FP_CD
,a.BDGT_REC_LVL_CD
,a.ACCT_SF_CD
,a.ACCT_PND_SF_CD
,a.FIN_EXT_ENC_SF_CD
,a.FIN_INT_ENC_SF_CD
,a.FIN_PRE_ENC_SF_CD
,a.FIN_OBJ_PRSCTRL_CD
,a.CG_CFDA_NBR
,a.ACCT_OFF_CMP_IND
,a.ACCT_CLOSED_IND
,CG_ACCT_RESP_ID
,b.UC_LOC_CD
,b.UC_ACCT_NBR
,b.UC_FUND_NBR
,b.UCI_CAPITAL_CAT_CD
FROM ca_account_t a
LEFT OUTER JOIN ca_account_ext_t b on (a.FIN_COA_CD = b.FIN_COA_CD and a.ACCOUNT_NBR = b.ACCOUNT_NBR)
WHERE
a.ACCT_CLOSED_IND <> 'Y'
AND (a.ACCT_EXPIRATION_DT >= getdate() or a.ACCT_EXPIRATION_DT IS NULL)
AND a.ACCT_EFFECT_DT <= GETDATE()
AND ((a.FIN_COA_CD='<kfsChartCode1>' AND ACCOUNT_NBR='<kfsAcctNumber1>') OR
(a.FIN_COA_CD='<kfsChartCode2>' AND ACCOUNT_NBR='<kfsAcctNumber2>') OR
. . . etc
)
ORG CODE = all children orgs...
|
Result Schema: A list of following elements (AccountDetails.java)
| DB Parameter | Java Parameter | Description | Data Type | Example |
|---|---|---|---|---|
| ORG_COA_CD | kfsOrgChart | KFS Chart Code (the chart that the org belongs to) | String(2) | 'IR' |
| ORG_CD | kfsOrgCode | KFS Organization Code (the org the account belongs to) | String(4) | '1234' |
| FIN_COA_CD | kfsChartCode | KFS Chart Code (the chart that the account belongs to) | String (2) | 'IR' |
| ACCOUNT_NBR | kfsAcctNumber | KFS Account Number | String (7) | '1234567' |
| ACCOUNT_NM | kfsAcctName | KFS Account Name | String (40) | |
| ACCT_FSC_OFC_UID | kfsAcctFiscalOfficerId | KFS Account Fiscal Officer ID | String | |
| ACCT_SPVSR_UNVL_ID | kfsAcctSupervisorId | KFS Account Supervisor ID | String | |
| ACCT_MGR_UNVL_ID | kfsAcctManagerId | KFS Account Manager ID | String | |
| ORG_CD | kfsOrgCode | KFS Organization Code | String | |
| ACCT_TYP_CD | kfsAcctTypeCode | KFS Account Type Code | String | |
| ACCT_PHYS_CMP_CD | kfsAcctCampusCode | KFS Account Campus Code | String | |
| SUB_FUND_GRP_CD | kfsSubFundCode | KFS Sub Fund Group Code | String | |
| ACCT_FRNG_BNFT_CD | kfsAcctFringeBenefitCode | KFS Account Fringe Benefit Code | String | |
| FIN_HGH_ED_FUNC_CD | kfsHigherEduFundCode | KFS Higher Education Function Code | String | |
| ACCT_RSTRC_STAT_CD | kfsAcctRestrictedCode | KFS Account Restricted Status Code | String | |
| ACCT_RSTRC_STAT_DT | kfsAcctRestrictedDate | KFS Account Restricted Status Date | String | |
| ACCT_CITY_NM | kfsAcctCity | KFS Account City Name | String | |
| ACCT_STATE_CD | kfsAcctState | KFS Account State Code | String | |
| ACCT_STREET_ADDR | kfsAcctAddress | KFS Account Street Address | String | |
| ACCT_ZIP_CD | kfsAcctZip | KFS Account Zip Code | String | |
| RPTS_TO_FIN_COA_CD | kfsReportToChartCode | KFS Reports To Chart Code | String | |
| RPTS_TO_ACCT_NBR | kfsReportToAcctNumber | KFS Reports To Account Number | String | |
| ACCT_CREATE_DT | kfsAcctCreateDate | KFS Account Create Date | String | |
| ACCT_EFFECT_DT | kfsAcctEffectiveDate | KFS Account Effective Date | String | |
| ACCT_EXPIRATION_DT | kfsAcctExpDate | KFS Account Expiration Date | String | |
| CONT_FIN_COA_CD | kfsContChartCode | KFS Continuation Chart Code | String | |
| CONT_ACCOUNT_NBR | kfsContAcctNumber | KFS Continuation Account Number | String | |
| ENDOW_FIN_COA_CD | kfsEndowChartCode | KFS Endowment Chart Code | String | |
| ENDOW_ACCOUNT_NBR | kfsEndowAcctNumber | KFS Endowment Account Number | String | |
| CONTR_CTRL_FCOA_CD | kfsCandGChartCode | KFS C&G Control Chart Code | String | |
| CONTR_CTRLACCT_NBR | kfsCandGAcctNumber | KFS C&G Control Account Number | String | |
| INCOME_FIN_COA_CD | kfsIncomeChartCode | KFS Income Stream Chart Code | String | |
| INCOME_ACCOUNT_NBR | kfsIncomeAcctNumber | KFS Income Stream Account Number | String | |
| ACCT_ICR_TYP_CD | kfsICRTypeCode | KFS ICR Type Code | String | |
| AC_CSTM_ICREXCL_CD | kfsCustomICRCode | KFS Custom ICR Code | String | |
| FIN_SERIES_ID | kfsICRRateCode | KFS ICR Rate Code | String | |
| ICR_FIN_COA_CD | kfsICRChartCode | KFS ICR Credit Chart Code | String | |
| ICR_ACCOUNT_NBR | kfsICRAcctNumber | KFS ICR Credit Account Number | String | |
| ACCT_IN_FP_CD | kfsTPSFCode | KFS Transaction Processing Sufficient Funds Check Code | String | |
| BDGT_REC_LVL_CD | kfsBudgetLevelCode | KFS Budget Recording Level Code | String | |
| ACCT_SF_CD | kfsAcctSFCode | KFS Account Sufficient Fund Check Code | String | |
| ACCT_PND_SF_CD | kfsAcctPSFCode | KFS Account Pending Sufficient Fund Check Code | String | |
| FIN_EXT_ENC_SF_CD | kfsEESFCode | KFS External Encumbrance Sufficient Fund Check Code | String | |
| FIN_INT_ENC_SF_CD | kfsIESFCode | KFS Internal Encumbrance Sufficient Fund Check Code | String | |
| FIN_PRE_ENC_SF_CD | kfsPESFCode | KFS Pre-Encumbrance Sufficient Fund Check Code | String | |
| FIN_OBJ_PRSCTRL_CD | kfsObjPCCode | KFS Object Presence Control Code | String | |
| CG_CFDA_NBR | kfsCGCFDANumber | KFS CG CFDA number | String | |
| ACCT_OFF_CMP_IND | kfsAcctOffCampusCode | KFS Account Off Campus Indicator Code | String | |
| ACCT_CLOSED_IND | kfsAcctClosedCode | KFS Account Closed Indicator Code | String | |
| CG_ACCT_RESP_ID | kfsAcctRespId | KFS Account Responsibility ID | String | |
| UC_LOC_CD | ucLocationCode | FS Location Code (legacy) | String(1) | |
| UC_ACCT_NBR | ucAccountCode | FS Account Code (legacy) | String(6) | |
| UC_FUND_NBR | ucFundCode | FS Fund Code (legacy) | String(5) |
...