001 /*
002 * Copyright 2011 The Kuali Foundation.
003 *
004 * Licensed under the Educational Community License, Version 2.0 (the "License");
005 * you may not use this file except in compliance with the License.
006 * You may obtain a copy of the License at
007 *
008 * http://www.opensource.org/licenses/ecl2.php
009 *
010 * Unless required by applicable law or agreed to in writing, software
011 * distributed under the License is distributed on an "AS IS" BASIS,
012 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
013 * See the License for the specific language governing permissions and
014 * limitations under the License.
015 */
016 package org.kuali.kfs.module.endow;
017
018 import org.kuali.rice.kns.util.KualiInteger;
019
020
021 public class EndowPropertyConstants {
022
023 // Endowment common fields
024 public static final String KUALICODEBASE_CODE = "code";
025 public static final String KUALICODEBASE_NAME = "name";
026 public static final String KUALICODEBASE_ACTIVE_INDICATOR = "active";
027 public static final String ENDOWCODEBASE_CODE = "code";
028 public static final String ENDOWCODEBASE_DESC = "description";
029 public static final String ENDOWCODEBASE_ACTIVE_INDICATOR = "active";
030
031 // Security Reporting Group
032 public static final String SECURITY_REPORTING_GROUP_ORDER = "securityReportingGrpOrder";
033 public static final String SECURITY_REPORTING_GROUP_ACTIVE_INFICATOR = "active";
034
035 // Endowment Transaction
036 public static final String ENDOWMENT_TRANSACTION_GL_LINKS = "glLinks";
037
038 // Class Code
039 public static final String CLASS_CODE_SEC_REPORTING_GRP = "securityReportingGrp";
040 public static final String CLASS_CODE_SEC_ACCRUAL_METHOD = "securityAccrualMethod";
041 public static final String CLASS_CODE_SEC_END_TRANSACTION_CODE = "securityEndowmentTransactionCode";
042 public static final String CLASS_CODE_SEC_INCOME_END_TRANSACTION_CODE = "securityIncomeEndowmentTransactionPostCode";
043 public static final String CLASS_CODE_TAX_LOT_INDICATOR = "taxLotIndicator";
044 public static final String CLASS_CODE_TYPE = "classCodeType";
045 public static final String CLASS_CODE_VALUATION_METHOD = "valuationMethod";
046 public static final String CLASS_CODE_ENDOWMENT_TRANSACTION = "endowmentTransactionCode";
047 public static final String CLASS_CODE_INCOME_ENDOWMENT_TRANSACTION_POST = "incomeEndowmentTransactionPost";
048
049 // Frequency Code
050 public static final String FREQUENCY_TYPE = "frequencyType";
051 public static final String FREQUENCY_WEEK_DAY = "frequencyWeekDay";
052 public static final String FREQUENCY_MONTH = "frequencyMonth";
053 public static final String FREQUENCY_DAY_IN_MONTH = "dayInMonth";
054 public static final String FREQUENCY_MONTHLY_OCCURENCE = "monthlyOccurence";
055
056 // Security
057 public static final String SECURITY_ID = "id";
058 public static final String SECURITY_USER_ENTERED_ID_PREFIX = "userEnteredSecurityIDprefix";
059 public static final String SECURITY_DESCRIPTION = "description";
060 public static final String SECURITY_TICKER_SYMBOL = "tickerSymbol";
061 public static final String SECURITY_CLASS_CODE = "securityClassCode";
062 public static final String SECURITY_SUBCLASS_CODE = "securitySubclassCode";
063 public static final String SECURITY_MATURITY_DATE = "maturityDate";
064 public static final String SECURITY_UNIT_VALUE = "unitValue";
065 public static final String SECURITY_UNITS_HELD = "unitsHeld";
066 public static final String SECURITY_VALUATION_DATE = "valuationDate";
067 public static final String SECURITY_UNIT_VALUE_SOURCE = "unitValueSource";
068 public static final String SECURITY_PREVIOUS_UNIT_VALUE = "previousUnitValue";
069 public static final String SECURITY_PREVIOUS_UNIT_VALUE_DATE = "previousUnitValueDate";
070 public static final String SECURITY_CARRY_VALUE = "carryValue";
071 public static final String SECURITY_MARKET_VALUE = "marketValue";
072 public static final String SECURITY_LAST_TRANSACTION_DATE = "lastTransactionDate";
073 public static final String SECURITY_INCOME_PAY_FREQUENCY = "incomePayFrequency";
074 public static final String SECURITY_INCOME_NEXT_PAY_DATE = "incomeNextPayDate";
075 public static final String SECURITY_INCOME_RATE = "incomeRate";
076 public static final String SECURITY_INCOME_CHANGE_DATE = "incomeChangeDate";
077 public static final String SECURITY_ISSUE_DATE = "issueDate";
078 public static final String SECURITY_DIVIDEND_RECORD_DATE = "dividendRecordDate";
079 public static final String SECURITY_EX_DIVIDEND_DATE = "exDividendDate";
080 public static final String SECURITY_DIVIDEND_PAY_DATE = "dividendPayDate";
081 public static final String SECURITY_DIVIDEND_AMOUNT = "dividendAmount";
082 public static final String SECURITY_COMMITMENT_AMOUNT = "commitmentAmount";
083 public static final String SECURITY_FOREIGN_WITHHOLD_PERCENTAGE = "foreignWithholdPercentage";
084 public static final String SECURITY_NEXT_FISCAL_YEAR_DISTRIBUTION_AMOUNT = "nextFiscalYearDistributionAmount";
085 public static final String SECURITY_CURRENT_HOLDERS = "currentHolders";
086 public static final String SECURITY_HOLDERS_IN_HISTORY = "holdersInHistory";
087 public static final String SECURITY_CLASS_CODE_REF = "classCode";
088 public static final String SECURITY_SUBCLASS_CODE_REF = "subclassCode";
089 public static final String SECURITY_FREQUENCY_CODE_REF = "frequencyCode";
090 public static final String SECURITY_VALUE_BY_MARKET = "securityValueByMarket";
091 public static final String SECURITY_ACTIVE_INDICATOR = "active";
092
093 public static final String REPORTING_GROUP_DESC = "classCode.reportingGroup.securityReportingGrpDesc";
094 public static final String ACCRUAL_METHOD_DESC = "classCode.accrualMethod.accrualMethodDesc";
095 public static final String TRANSACTION_CODE_DESC = "classCode.endowmentTransactionCode.codeAndDescription";
096 public static final String INCOME_TRANSACTION_CODE_DESC = "classCode.incomeEndowmentTransactionPost.codeAndDescription";
097
098 // HoldingTaxLot fields
099 public static final String HOLDING_TAX_LOT_KEMID = "kemid";
100 public static final String HOLDING_TAX_LOT_SECURITY_ID = "securityId";
101 public static final String HOLDING_TAX_LOT_REGISTRATION_CODE = "registrationCode";
102 public static final String HOLDING_TAX_LOT_NUMBER = "lotNumber";
103 public static final String HOLDING_TAX_LOT_INCOME_PRINCIPAL_INDICATOR = "incomePrincipalIndicator";
104 public static final String HOLDING_TAX_LOT_BALANCE_DATE = "balanceDate";
105 public static final String HOLDING_TAX_LOT_ACQUIRED_DATE = "acquiredDate";
106 public static final String HOLDING_TAX_LOT_UNITS = "units";
107 public static final String HOLDING_TAX_LOT_COST = "cost";
108 public static final String HOLDING_TAX_LOT_ACRD_INC_DUE = "currentAccrual";
109
110 // MonthEndDate fields
111 public static final String MONTH_END_DATE_ID = "monthEndDateId";
112 public static final String MONTH_END_DATE = "monthEndDate";
113
114 // HoldingHistory fields
115 public static final String HOLDING_HISTORY_KEMID = "kemid";
116 public static final String HOLDING_HISTORY_MONTH_END_DATE_ID = "monthEndDateId";
117 public static final String HOLDING_HISTORY_SECURITY_ID = "securityId";
118 public static final String HOLDING_HISTORY_INCOME_PRINCIPAL_INDICATOR = "incomePrincipalIndicator";
119 public static final String HOLDING_HISTORY_SECURITY_CLASS_CODE = "feeClassCode";
120 public static final String HOLDING_HISTORY_FEE_METHOD_CODE = "feeMethodCode";
121 public static final String HOLDING_HISTORY_UNITS = "units";
122 public static final String HOLDING_HISTORY_ESTIMATED_INCOME = "estimatedIncome";
123 public static final String HOLDING_HISTORY_MARKET_VALUE = "marketValue";
124 public static final String HOLDING_HISTORY_REMAIDER_OF_FY_ESTIMATED_INCOME = "remainderOfFYEstimatedIncome";
125 public static final String HOLDING_HISTORY_NEXT_FY_ESTIMATED_INCOME = "nextFYEstimatedIncome";
126
127 // CurrentTaxLotBalance fields
128 public static final String CURRENT_TAX_LOT_BALANCE_SECURITY_ID = "securityId";
129 public static final String CURRENT_TAX_LOT_BALANCE_INCOME_PRINCIPAL_INDICATOR = "incomePrincipalIndicator";
130 public static final String CURRENT_TAX_LOT_BALANCE_SECURITY_CLASS_CODE = "feeClassCode";
131
132 // KEMID
133 public static final String KEMID = "kemid";
134 public static final String KEMID_TYPE_CODE = "typeCode";
135 public static final String KEMID_USER_ENTERED_MOD10 = "userEnteredKemidMod10";
136 public static final String KEMID_DORMANT_IND = "dormantIndicator";
137 public static final String KEMID_CLOSED_IND = "close";
138 public static final String KEMID_CLOSED_TO_KEMID = "closedToKEMID";
139 public static final String KEMID_CLOSE_CODE = "closeCode";
140 public static final String KEMID_DISPOSITION_OF_FUNDS = "dispositionOfFunds";
141 public static final String KEMID_DATE_CLOSED = "dateClosed";
142 public static final String KEMID_AGREEMENTS_TAB = "kemidAgreements";
143 public static final String KEMID_SOURCE_OF_FUNDS_TAB = "kemidSourcesOfFunds";
144 public static final String KEMID_BENEFITTING_ORGS_TAB = "kemidBenefittingOrganizations";
145 public static final String KEMID_GENERAL_LEDGER_ACCOUNTS_TAB = "kemidGeneralLedgerAccounts";
146 public static final String KEMID_AUTHORIZATIONS_TAB = "kemidAuthorizations";
147 public static final String KEMID_PAY_INSTRUCTIONS_TAB = "kemidPayoutInstructions";
148 public static final String KEMID_USE_CRITERIA_TAB = "kemidUseCriteria";
149 public static final String KEMID_SPECIAL_INSTRUCTIONS_TAB = "kemidSpecialInstructions";
150 public static final String KEMID_REPORT_GROUP_TAB = "kemidReportGroups";
151 public static final String KEMID_DONOR_STATEMENTS_TAB = "kemidDonorStatements";
152 public static final String KEMID_COMBINE_DONOR_STATEMENTS_TAB = "kemidCombineDonorStatements";
153 public static final String KEMID_FEES_TAB = "kemidFees";
154 public static final String KEMID_CLOSED = "closed_ind";
155 public static final String KEMID_CASH_SWEEP_MDL_ID = "cashSweepModelId";
156 public static final String KEMID_TYP_PRIN_RESTR_CD = "principalRestrictionCode";
157 public static final String KEMID_PRPS_CD = "purposeCode";
158
159 // links
160 public static final String KEMID_CURRENT_AVAILABLE_FUNDS = "currentAvailableFunds";
161 public static final String KEMID_CURRENT_BALANCES = "currentBalances";
162 public static final String KEMID_HISTORICAL_BALANCES = "historicalBalances";
163 public static final String KEMID_TICKLERS = "ticklers";
164 public static final String KEMID_RECURRING_TRANSFERS = "recurringTransfers";
165
166 public static final String KEMID_AGREEMENTS_SECTION = "agreements";
167 public static final String KEMID_SOURCE_OF_FUNDS_SECTION = "sourcesOfFunds";
168 public static final String KEMID_BENEFITTING_ORGS_SECTION = "benefittingOrganizations";
169 public static final String KEMID_GENERAL_LEDGER_ACCOUNTS_SECTION = "generalLedgerAccounts";
170 public static final String KEMID_PAY_INSTRUCTIONS_SECTION = "payoutInstructions";
171 public static final String KEMID_USE_CRITERIA_SECTION = "useCriteria";
172 public static final String KEMID_SPECIAL_INSTRUCTIONS_SECTION = "specialInstructions";
173 public static final String KEMID_FEES_SECTION = "fees";
174 public static final String KEMID_REPORT_GROUP_SECTION = "reportGroup";
175 public static final String KEMID_DONOR_STATEMENTS_SECTION = "donorStatements";
176 public static final String KEMID_COMBINE_DONOR_STATEMENTS_SECTION = "combineDonorStatements";
177
178 // KemidAgreement
179 public static final String KEMID_AGRMNT_ID = "agreementId";
180 public static final String KEMID_AGRMNT_TYP_CD = "agreementTypeCode";
181 public static final String KEMID_AGRMNT_TYPE = "agreementType";
182 public static final String KEMID_AGRMNT_STAT_CD = "agreementStatusCode";
183 public static final String KEMID_AGRMNT_STATUS = "agreementStatus";
184 public static final String KEMID_AGRMNT_STAT_DT = "agreementStatusDate";
185 public static final String KEMID_AGRMNT_OTHR_DOC = "otherAgreementDocumentation";
186 public static final String KEMID_AGRMNT_DONR_INTENT = "donorIntentFromAgreement";
187 public static final String KEMID_AGRMNT_COMM = "comments";
188 public static final String KEMID_AGRMNT_ACTIVE_IND = "active";
189
190 //KEMID ETRAN GL Link
191 public static final String KEMID_ETRAN_GL_LNK_CHART_CD = "chartCode";
192 public static final String KEMID_ETRAN_GL_LNK_ETRAN_CD = "endowmentTransactionCode";
193 public static final String KEMID_ETRAN_GL_LNK_ROW_ACTIVE_IND = "active";
194
195 // KEMID Source Of Funds
196 public static final String KEMID_FND_SRC_SEQ_NBR = "kemidFundSourceSequenceNumber";
197 public static final String KEMID_FND_SRC_CD = "fundSourceCode";
198 public static final String KEMID_FND_SRC = "fundSource";
199 public static final String KEMID_FND_SRC_OPND_FROM_KEMID = "openedFromKemid";
200 public static final String KEMID_FND_SRC_OPND_FROM_KEMID_OBJ_REF = "openedFromKemidObjRef";
201 public static final String KEMID_FND_SRC_HIST = "fundHistory";
202 public static final String KEMID_FND_SRC_ADDITIONAL_DATA = "additionalSourceData";
203 public static final String KEMID_FND_SRC_ACTIVE_IND = "active";
204
205 // KEMID Benefitting Org
206 public static final String KEMID_BENE_KEMID = "kemid";
207 public static final String KEMID_BENE_ORG_SEQ_NBR = "benefittingOrgSeqNumber";
208 public static final String KEMID_BENE_ORG_CD = "benefittingOrgCode";
209 public static final String KEMID_BENE_ORG = "organization";
210 public static final String KEMID_BENE_CHRT_CD = "benefittingChartCode";
211 public static final String KEMID_BENE_CHRT = "chart";
212 public static final String KEMID_BENE_ORG_PERCENT = "benefitPrecent";
213 public static final String KEMID_BENE_ORG_START_DATE = "startDate";
214 public static final String KEMID_BENE_ORG_LAST_CHG_DATE = "lastChangeDate";
215 public static final String KEMID_BENE_ORG_ACTIVE_IND = "active";
216
217 // Chart of Account Organization - should be moved to the COA module later
218 public static final String CA_ORG_CAMPUS_CD = "organizationPhysicalCampusCode";
219 public static final String CA_ORG_CHRT_CD = "chartOfAccountsCode";
220 public static final String CA_ORG_CD = "organizationCode";
221
222 // KEMID General Ledger Account
223 public static final String KEMID_GL_ACCOUNT_IP_INDICATOR_CD = "incomePrincipalIndicatorCode";
224 public static final String KEMID_GL_ACCOUNT_CHART_CD = "chartCode";
225 public static final String KEMID_GL_ACCOUNT_CHART = "chart";
226 public static final String KEMID_GL_ACCOUNT_NBR = "accountNumber";
227 public static final String KEMID_GL_ACCOUNT = "account";
228 public static final String KEMID_GL_ACCOUNT_ROW_ACTV_IND = "active";
229
230
231 // KEMID Payout Instructions
232 public static final String KEMID_PAY_INC_SEQ_NBR = "payoutIncomeSequenceNumber";
233 public static final String KEMID_PAY_INC_KEMID = "kemid";
234 public static final String KEMID_PAY_INC_TO_KEMID = "payIncomeToKemid";
235 public static final String KEMID_PAY_INC_TO_KEMID_OBJ_REF = "payIncomeToKemidObjRef";
236 public static final String KEMID_PAY_INC_PERCENT_OF_INC_TO_PAY_TO_KEMID = "percentOfIncomeToPayToKemid";
237 public static final String KEMID_PAY_INC_START_DATE = "startDate";
238 public static final String KEMID_PAY_INC_END_DATE = "endDate";
239
240 // KEMID Use Criteria
241 public static final String KEMID_USE_CRIT_SEQ = "useCriteriaSeq";
242 public static final String KEMID_USE_CRIT_CD = "useCriteriaCode";
243 public static final String KEMID_USE_CRIT = "useCriteria";
244 public static final String KEMID_USE_CRIT_ADDITIONAL_INFO = "useCriteriaAdditionalInfo";
245 public static final String KEMID_USE_CRIT_ACTIVE_IND = "active";
246
247 // KEMID Special Instruction
248 public static final String KEMID_SPEC_INSTR_SEQ = "instructionSeq";
249 public static final String KEMID_SPEC_INSTR_CD = "agreementSpecialInstructionCode";
250 public static final String KEMID_SPEC_INSTR = "agreementSpecialInstruction";
251 public static final String KEMID_SPEC_INSTR_COMMENTS = "comments";
252 public static final String KEMID_SPEC_INSTR_START_DATE = "instructionStartDate";
253 public static final String KEMID_SPEC_INSTR_END_DATE = "instructionEndDate";
254
255 // KEMID Fee Method
256 public static final String KEMID_FEE_MTHD_CD = "feeMethodCode";
257 public static final String KEMID_FEE_MTHD = "feeMethod";
258 public static final String KEMID_FEE_SEQ = "feeMethodSeq";
259 public static final String KEMID_FEE_CHARGE_FEE_TO_KEMID = "chargeFeeToKemid";
260 public static final String KEMID_FEE_CHARGE_FEE_TO_KEMID_OBJ_REF = "chargeFeeToKemidObjRef";
261 public static final String KEMID_FEE_PERCENT_OF_FEE_CHARGED_TO_INCOME = "percentOfFeeChargedToIncome";
262 public static final String KEMID_FEE_PERCENT_OF_FEE_CHARGED_TO_PRINCIPAL = "percentOfFeeChargedToPrincipal";
263 public static final String KEMID_FEE_ACCRUE_FEES = "accrueFees";
264 public static final String KEMID_FEE_TOTAL_ACCRUED_FEES = "totalAccruedFees";
265 public static final String KEMID_FEE_WAIVE_FEES = "waiveFees";
266 public static final String KEMID_FEE_TOTAL_WAIVED_FEES_THIS_FISCAL_YEAR = "totalWaivedFeesThisFiscalYear";
267 public static final String KEMID_FEE_TOTAL_WAIVED_FEES = "totalWaivedFees";
268 public static final String KEMID_FEE_START_DATE = "feeStartDate";
269 public static final String KEMID_FEE_END_DATE = "feeEndDate";
270
271 // KEMID Report Group
272 public static final String KEMID_REPORT_GRP_SEQ = "combineGroupSeq";
273 public static final String KEMID_REPORT_GRP_CD = "combineGroupCode";
274 public static final String KEMID_REPORT_GRP = "combineGroup";
275 public static final String KEMID_REPORT_GRP_DATE_ADDED = "dateAdded";
276 public static final String KEMID_REPORT_GRP_DATE_TERMINATED = "dateTerminated";
277
278 // KEMID Donor Statement
279 public static final String KEMID_DONOR_STATEMENT_ID = "donorId";
280 public static final String KEMID_DONOR_STATEMENT_DONOR = "donor";
281 public static final String KEMID_DONOR_STATEMENT_SEQ = "donorSeq";
282 public static final String KEMID_DONOR_STATEMENT_CD = "donorStatementCode";
283 public static final String KEMID_DONOR_STATEMENT = "donorStatement";
284 public static final String KEMID_DONOR_STATEMENT_COMBINE_WITH_DONOR_ID = "combineWithDonorId";
285 public static final String KEMID_DONOR_STATEMENT_COMBINE_WITH_DONOR = "combineWithDonor";
286 public static final String KEMID_DONOR_STATEMENT_DONOR_LABEL = "donorLabel";
287 public static final String KEMID_DONOR_STATEMENT_DONOR_LABEL_OBJ_REF = "donorLabelObjRef";
288 public static final String KEMID_DONOR_STATEMENT_TERMINATION_REASON = "terminationReason";
289 public static final String KEMID_DONOR_STATEMENT_TERMINATION_DATE = "terminationDate";
290
291 // KEMID Combine Donor Statement
292 public static final String KEMID_COMBINE_DONOR_STATEMENT_SEQ = "combineDonorSeq";
293 public static final String KEMID_COMBINE_DONOR_STATEMENT_TERMINATION_DATE = "terminateCombineDate";
294 public static final String KEMID_COMBINE_DONOR_STATEMENT_WITH_KEMID = "combineWithKemid";
295 public static final String KEMID_COMBINE_DONOR_STATEMENT_WITH_KEMID_OBJ_REF = "combineWithKemidObjRef";
296
297 // KEMID Authorizations
298 public static final String KEMID_AUTHORIZATIONS_ROLE_SEQ_NBR = "roleSequenceNumber";
299 public static final String KEMID_AUTHORIZATIONS_ROLE_ID = "roleId";
300 public static final String KEMID_AUTHORIZATIONS_ROLE_PRNCPL_ID = "rolePrincipalId";
301
302 // GLLink
303 public static final String GL_LINK_ETRAN_CD = "endowmentTransactionCode";
304 public static final String GL_LINK_CHART_CD = "chartCode";
305 public static final String GL_LINK_OBJECT_CD = "object";
306 public static final String GL_LINK_FINANCIAL_OBJECT_CODE = "financialObjectCode";
307
308 // Pooled Fund Control
309 public static final String POOL_SECURITY_ID = "pooledSecurityID";
310 public static final String DISTRIBUTE_GAINS_LOSSES_IND = "distributeGainsAndLossesIndicator";
311
312 // PooledFundValue
313 public static final String VALUE_EFFECTIVE_DATE = "valueEffectiveDate";
314 public static final String VALUATION_DATE = "valuationDate";
315 public static final String INCOME_DISTRIBUTION_PER_UNIT = "incomeDistributionPerUnit";
316 public static final String INCOME_DISTRIBUTION_COMPLETE = "incomeDistributionComplete";
317 public static final String LONG_TERM_GAIN_LOSS_DISTRIBUTION_PER_UNIT = "longTermGainLossDistributionPerUnit";
318 public static final String SHORT_TERM_GAIN_LOSS_DISTRIBUTION_PER_UNIT = "shortTermGainLossDistributionPerUnit";
319 public static final String DISTRIBUTE_INCOME_ON_DATE = "distributeIncomeOnDate";
320 public static final String DISTRIBUTE_LONG_TERM_GAIN_LOSS_ON_DATE = "distributeLongTermGainLossOnDate";
321 public static final String DISTRIBUTE_SHORT_TERM_GAIN_LOSS_ON_DATE = "distributeShortTermGainLossOnDate";
322 public static final String ST_GAIN_LOSS_DISTR_COMPL = "shortTermGainLossDistributionComplete";
323 public static final String LT_GAIN_LOSS_DISTR_COMPL = "longTermGainLossDistributionComplete";
324
325
326 // Cash Sweep Model
327 public static final String CASH_SWEEP_MODEL_ID = "cashSweepModelID";
328 public static final String CASH_SWEEP_MODEL_NEXT_DUE_DATE = "cashSweepNextDueDate";
329 public static final String CASH_SWEEP_MODEL_FREQUENCY_CDOE = "cashSweepFrequencyCode";
330 public static final String CASH_SWEEP_MODEL_ACTIVE_INDICATOR = "active";
331
332 // Automated Cash Investment Model
333 public static final String ACI_MODEL_ID = "aciModelID";
334 public static final String INVESTMENT_1_PERCENT = "investment1Percent";
335 public static final String INVESTMENT_2_PERCENT = "investment2Percent";
336 public static final String INVESTMENT_3_PERCENT = "investment3Percent";
337 public static final String INVESTMENT_4_PERCENT = "investment4Percent";
338 public static final String ACI_MODEL_NEXT_DUE_DATE = "aciNextDueDate";
339 public static final String ACI_MODEL_FREQUENCY_CDOE = "aciFrequencyCode";
340 public static final String ACI_MODEL_ACTIVE_INDICATOR = "active";
341
342 // PurposeCode
343 public static final String PURPOSE_INCOME_CAE_CD = "incomeCAECode";
344 public static final String PURPOSE_PRINCIPAL_CAE_CD = "principalCAECode";
345
346 // KEMID CAE
347 public static final String CAE_TYPE_CODE_ID = "caeTypeCode";
348
349 // KEMID Donor
350 public static final String DONR_ID = "donorID";
351
352 // KEMID Type Code
353 public static final String TYPE_CODE = "code";
354 public static final String TYPE_INC_RESTR_CD = "incomeRestrictionCode";
355 public static final String TYPE_PRINCIPAL_RESTR_CD = "incomeRestrictionCode";
356 public static final String TYPE_INCOME_ACI_MODEL_ID = "incomeACIModelId";
357 public static final String TYPE_PRINCIPAL_ACI_MODEL_ID = "principalACIModelId";
358
359 // Type Restrict Code
360 public static final String TYPE_RESTR_PERM_IND = "permanentIndicator";
361
362 // KEMID Type Fee Method
363 public static final String FEE_METHOD = "feeMethod";
364 public static final String FEE_BASE_CD = "feeBaseCode";
365
366 // KEMID Fee Method
367 public static final String FEE_METHOD_CODE = "feeMethodCode";
368 public static final String FEE_METHOD_FREQUENCY_CODE = "feeFrequencyCode";
369 public static final String FEE_METHOD_NEXT_PROCESS_DATE = "feeNextProcessDate";
370 public static final String FEE_METHOD_LAST_PROCESS_DATE = "feeLastProcessDate";
371
372 // KEMID Fee Class Code
373 public static final String FEE_CLASS_CODE = "classCode";
374
375 // KEMID Fee Security
376 public static final String FEE_SECURITY_CODE = "securityCode";
377 public static final String FEE_SECURITY = "security"; // object
378
379 // KEMID Fee Payment Type
380 public static final String FEE_PAYMENT_TYPE_CODE = "paymentTypeCode";
381
382 // KEMID Fee Transaction Type
383 public static final String FEE_TRANSACTION_TYPE_CODE = "transactionTypeCode";
384 public static final String FEE_TRANSACTION_DOCUMENT_TYPE_CODE = "documentTypeName";
385 public static final String FEE_TRANSACTION_INCLUDE = "include";
386
387 // KEMID Fee Rate Definition Code
388 public static final String FEE_RATE_DEFINITION_CODE = "feeRateDefinitionCode";
389
390 // KEMID Fee Endowment Transaction Code
391 public static final String FEE_ENDOWMENT_TRANSACTION_CODE = "endowmentTransactionCode";
392 public static final String FEE_ENDOWMENT_TRANSACTION_INCLUDE = "include";
393
394 // KEMID Current Balance
395 public static final String CURRENT_BAL_TOTAL_MARKET_VALUE = "totalMarketValue";
396 public static final String CURRENT_BAL_PURPOSE_CD = "kemidObj.purposeCode";
397 public static final String CURRENT_BAL_KEMID_BALANCE_DATE = "balanceDate";
398 public static final String CURRENT_BAL_CLOSED_INDICATOR = "kemidObj.close";
399 public static final String CURRENT_BAL_KEMID_SHORT_TTL = "kemidObj.shortTitle";
400
401 // KEMID Current Balance Detail
402 public static final String KEMID_CRNT_BAL_DET_INC_AT_MARKET = "incomeAtMarket";
403 public static final String KEMID_CRNT_BAL_DET_PRIN_AT_MARKET = "principalAtMarket";
404 public static final String KEMID_CRNT_BAL_KEMID_SHORT_TTL = "kemidObj.shortTitle";
405 public static final String KEMID_CRNT_BAL_PURPOSE_DESC = "kemidObj.purpose.name";
406
407 // KEMID Current Reporting Group
408 public static final String KEMID_CRNT_REP_GRP_SEC_ID = "securityId";
409 public static final String KEMID_CRNT_REP_GRP_CD = "reportingGroupCode";
410 public static final String KEMID_CRNT_REP_GRP_REGIS_CD = "registrationCode";
411 public static final String KEMID_CRNT_REP_GRP_IP_IND = "ipIndicator";
412 public static final String KEMID_CRNT_REP_GRP_UNITS = "units";
413 public static final String KEMID_CRNT_REP_GRP_CARRY_VAL = "carryVal";
414 public static final String KEMID_CRNT_REP_GRP_MVAL = "marketVal";
415 public static final String KEMID_CRNT_REP_GRP_FY_EST_INC = "nextFYEstimatedIncome";
416 public static final String KEMID_CRNT_REP_GRP_FY_REM_EST_INC = "remainderOfFYEstimatedIncome";
417 public static final String KEMID_CRNT_REP_GRP_ANNL_INC_EST = "annualEstimatedIncome";
418 public static final String KEMID_CRNT_REP_GRP_KEMID_SHORT_TTL = "kemidObj.shortTitle";
419 public static final String KEMID_CRNT_REP_GRP_PURPOSE_DESC = "kemidObj.purpose.name";
420 public static final String KEMID_CRNT_REP_GRP_DESC = "reportingGroup.name";
421 public static final String KEMID_CRNT_REP_GRP_IP_IND_DESC = "incomePrincipalIndicator.name";
422
423 // Current Tax Lot
424 public static final String CURRENT_TAX_LOT_KEMID = "kemid";
425 public static final String CURRENT_TAX_LOT_SECURITY_ID = "securityId";
426 public static final String CURRENT_TAX_LOT_REGIS_CD = "registrationCode";
427 public static final String CURRENT_TAX_LOT_LOT_NBR = "lotNumber";
428 public static final String CURRENT_TAX_LOT_IP_IND = "incomePrincipalIndicator";
429 public static final String CURRENT_TAX_LOT_IP_IND_DESC = "incomePrincipal.name";
430 public static final String CURRENT_TAX_LOT_UNITS = "units";
431 public static final String CURRENT_TAX_LOT_COST = "cost";
432 public static final String CURRENT_TAX_LOT_HOLDING_MVAL = "holdingMarketValue";
433 public static final String CURRENT_TAX_LOT_ACQUIRED_DATE = "acquiredDate";
434 public static final String CURRENT_TAX_LOT_ANN_EST_INC = "annualEstimatedIncome";
435 public static final String CURRENT_TAX_LOT_REMAINDER_OF_FY_EST_INC = "remainderOfFYEstimatedIncome";
436 public static final String CURRENT_TAX_LOT_NEXT_FY_EST_INC = "nextFYEstimatedIncome";
437 public static final String CURRENT_TAX_LOT_LAST_TRAN_DATE = "lastTransactionDate";
438 public static final String CURRENT_TAX_LOT_CURRENT_ACCRUAL = "currentAccrual";
439 public static final String CURRENT_TAX_LOT_PRIOR_ACCRUAL = "priorAccrual";
440 public static final String CURRENT_TAX_LOT_KEMID_SHORT_TTL = "kemidObj.shortTitle";
441 public static final String CURRENT_TAX_LOT_KEMID_PURPOSE_CD = "kemidObj.purposeCode";
442 public static final String CURRENT_TAX_LOT_BALANCE_DATE = "balanceDate";
443 public static final String CURRENT_TAX_LOT_KEMID_CLOSED_IND = "kemidObj.close";
444 public static final String CURRENT_TAX_LOT_REP_GRP = "security.classCode.securityReportingGrp";
445 public static final String CURRENT_TAX_LOT_REGIS_DESC = "registration.name";
446 public static final String CURRENT_TAX_LOT_SEC_DESC = "security.description";
447 public static final String CURRENT_TAX_LOT_PURPOSE_DESC = "kemidObj.purpose.name";
448 public static final String CURRENT_TAX_LOT_INC_PRIN_DESC = "incomePrincipal.name";
449
450 // KEMIDHistoricalBalance
451 public static final String KEMID_HIST_BAL_KEMID = "kemid";
452 public static final String KEMID_HIST_BAL_CLOSED_IND = "closedIndicator";
453 public static final String KEMID_HIST_BAL_DATE_ID = "historyBalanceDateId";
454 public static final String KEMID_HIST_BAL_PURPOSE_CD = "purposeCode";
455 public static final String KEMID_HIST_BAL_INC_AT_MARKET = "incomeAtMarket";
456 public static final String KEMID_HIST_BAL_PRINC_AT_MARKET = "principalAtMarket";
457 public static final String KEMID_HIST_BAL_TOTAL_MARKET_VAL = "totalMarketValue";
458 public static final String KEMID_HIST_BAL_ANNUAL_EST_INC = "annualEstimatedIncome"; // next 12 months estimated income
459 public static final String KEMID_HIST_BAL_REMAINDER_FY_EST_INC = "remainderFYEstimatedIncome";
460 public static final String KEMID_HIST_BAL_NEXT_FT_EST_INC = "nextFYEstimatedIncome";
461
462 // KEMIDHistoricalBalanceDetail
463 public static final String KEMID_HIST_BAL_DET_KEMID = "kemid";
464 public static final String KEMID_HIST_BAL_DET_PURPOSE_CODE = "kemidObj.purposeCode";
465 public static final String KEMID_HIST_BAL_DET_DATE_ID = "historyBalanceDateId";
466 public static final String KEMID_HIST_BAL_DET_INC_PRIN_IND = "incomePrincipalIndicator";
467 public static final String KEMID_HIST_BAL_DET_RPT_GRP_CD = "reportingGroupCode";
468 public static final String KEMID_HIST_BAL_DET_VAL_AT_MARKET = "valueAtMarket";
469 public static final String KEMID_HIST_BAL_DET_ANNUAL_EST_INC = "annualEstimatedIncome"; // next 12 months estimated
470 // income
471 public static final String KEMID_HIST_BAL_DET_INC_AT_MARKET = "incomeAtMarket";
472 public static final String KEMID_HIST_BAL_DET_PRINC_AT_MARKET = "principalAtMarket";
473 public static final String KEMID_HIST_BAL_DET_REMAINDER_FY_EST_INC = "remainderOfFYEstimatedIncome";
474 public static final String KEMID_HIST_BAL_DET_NEXT_FT_EST_INC = "nextFYEstimatedIncome";
475 public static final String KEMID_HIST_BAL_DET_KEMID_PURPOSE_DESC = "kemidObj.purpose.name";
476 public static final String KEMID_HIST_BAL_DET_KEMID_CLOSED_INDICATOR = "kemidObj.close";
477 public static final String KEMID_HIST_BAL_DET_KEMID_SHORT_TTL = "kemidObj.shortTitle";
478
479 // KEMID Historical Reporting Group
480 public static final String KEMID_HIST_REP_GRP_KEMID = "kemid";
481 public static final String KEMID_HIST_REP_GRP_LOT_NBR = "lotNumber";
482 public static final String KEMID_HIST_REP_GRP_ACQ_DATE = "acquiredDate";
483 public static final String KEMID_HIST_REP_GRP_COST = "cost";
484 public static final String KEMID_HIST_REP_GRP_CRNT_ACCR = "currentAccrual";
485 public static final String KEMID_HIST_REP_GRP_PRIOR_ACCR = "priorAccrual";
486 public static final String KEMID_HIST_REP_GRP_LAST_TRAN_DATA = "lastTransactionDate";
487 public static final String KEMID_HIST_REP_GRP_SEC_ID = "securityId";
488 public static final String KEMID_HIST_REP_GRP_CD = "reportingGroupCode";
489 public static final String KEMID_HIST_REP_GRP_REGIS_CD = "registrationCode";
490 public static final String KEMID_HIST_REP_GRP_IP_IND = "ipIndicator";
491 public static final String KEMID_HIST_REP_GRP_UNITS = "units";
492 public static final String KEMID_HIST_REP_GRP_CARRY_VAL = "carryVal";
493 public static final String KEMID_HIST_REP_GRP_MVAL = "marketVal";
494 public static final String KEMID_HIST_REP_GRP_FY_EST_INC = "nextFYEstimatedIncome";
495 public static final String KEMID_HIST_REP_GRP_FY_REM_EST_INC = "remainderOfFYEstimatedIncome";
496 public static final String KEMID_HIST_REP_GRP_ANNL_INC_EST = "annualEstimatedIncome";
497 public static final String KEMID_HIST_REP_GRP_KEMID_SHORT_TTL = "kemidObj.shortTitle";
498 public static final String KEMID_HIST_REP_GRP_PURPOSE_DESC = "kemidObj.purpose.name";
499 public static final String KEMID_HIST_REP_GRP_DESC = "reportingGroup.name";
500 public static final String KEMID_HIST_REP_GRP_IP_IND_DESC = "incomePrincipalIndicator.name";
501
502 // KEMID Historical Tax Lot
503 public static final String KEMID_HIST_TAX_LOT_KEMID = "kemid";
504 public static final String KEMID_HIST_TAX_LOT_SECURITY_ID = "securityId";
505 public static final String KEMID_HIST_TAX_LOT_REGIS_CD = "registrationCode";
506 public static final String KEMID_HIST_TAX_LOT_LOT_NBR = "lotNumber";
507 public static final String KEMID_HIST_TAX_LOT_IP_IND = "incomePrincipalIndicator";
508 public static final String KEMID_HIST_TAX_LOT_IP_IND_DESC = "incomePrincipal.name";
509 public static final String KEMID_HIST_TAX_LOT_UNITS = "units";
510 public static final String KEMID_HIST_TAX_LOT_COST = "cost";
511 public static final String KEMID_HIST_TAX_LOT_HOLDING_MVAL = "holdingMarketValue";
512 public static final String KEMID_HIST_TAX_LOT_ACQUIRED_DATE = "acquiredDate";
513 public static final String KEMID_HIST_TAX_LOT_ANN_EST_INC = "annualEstimatedIncome";
514 public static final String KEMID_HIST_TAX_LOT_REMAINDER_OF_FY_EST_INC = "remainderOfFYEstimatedIncome";
515 public static final String KEMID_HIST_TAX_LOT_NEXT_FY_EST_INC = "nextFYEstimatedIncome";
516 public static final String KEMID_HIST_TAX_LOT_LAST_TRAN_DATE = "lastTransactionDate";
517 public static final String KEMID_HIST_TAX_LOT_CURRENT_ACCRUAL = "currentAccrual";
518 public static final String KEMID_HIST_TAX_LOT_PRIOR_ACCRUAL = "priorAccrual";
519 public static final String KEMID_HIST_TAX_LOT_KEMID_SHORT_TTL = "kemidObj.shortTitle";
520 public static final String KEMID_HIST_TAX_LOT_KEMID_PURPOSE_CD = "kemidObj.purposeCode";
521 public static final String KEMID_HIST_TAX_LOT_BALANCE_DATE = "balanceDate";
522 public static final String KEMID_HIST_TAX_LOT_KEMID_CLOSED_IND = "kemidObj.close";
523 public static final String KEMID_HIST_TAX_LOT_REP_GRP = "security.classCode.securityReportingGrp";
524 public static final String KEMID_HIST_TAX_LOT_REGIS_DESC = "registration.name";
525 public static final String KEMID_HIST_TAX_LOT_SEC_DESC = "security.description";
526 public static final String KEMID_HIST_TAX_LOT_PURPOSE_DESC = "kemidObj.purpose.name";
527 public static final String KEMID_HIST_TAX_LOT_INC_PRIN_DESC = "incomePrincipal.name";
528
529 // KEMID fee method constants that are used in rule class
530 public static final String FEE_CLASS_CODES_COLLECTION_NAME = "feeClassCodes";
531 public static final String FEE_CLASS_CODE_INCLUDE = "include";
532 public static final String FEE_SECURITY_INCLUDE = "include";
533 public static final String FEE_SECURITY_COLLECTION_NAME = "feeSecurity";
534 public static final String FEE_TRANSACTION_TYPE_COLLECTION_NAME = "feeTransactions";
535 public static final String FEE_ENDOWMENT_TRANSACTION_CODE_COLLECTION_NAME = "feeEndowmentTransactionCodes";
536 public static final String FEE_PAYMENT_TYPE_COLLECTION_NAME = "feePaymentTypes";
537 public static final String FEE_CLASS_CODE_REF = "classCode";
538 public static final String FEE_SECURITY_REF = "security";
539 public static final String FEE_TRANSACTION_TYPE_REF = "transactionType";
540 public static final String FEE_TRANSACTION_ARCHIVE_REF = "transactionArchive";
541 public static final String FEE_ENDOWMENT_TRANSACTION_CODE_REF = "endowmentTransaction";
542 public static final String FEE_CLASS_CODE_ATTRIBUTE = "feeClassCode";
543 public static final String FEE_SECURITY_CODE_ATTRIBUTE = "securityCode";
544 public static final String FEE_TRANSACTION_TYPE_CODE_ATTRIBUTE = "transactionTypeCode";
545 public static final String FEE_TRANSACTION_DOCUMENT_TYPE_NAME_ATTRIBUTE = "documentTypeName";
546
547 public static final String FEE_ENDOWMENT_TRANSACTION_TYPE_CODE_ATTRIBUTE = "endowmentTransactionCode";
548 public static final String FEE_TYPE_CODE = "feeTypeCode";
549 public static final String FEE_BASE_CODE = "feeBaseCode";
550 public static final String FEE_BY_TRANSACTION_TYPE_CODE = "feeByTransactionType";
551 public static final String FEE_BY_ENDOWMENT_TRANSACTION_TYPE_CODE = "feeByETranCode";
552 public static final String FEE_EXPENSE_ENDOWMENT_TRANSACTION_CODE = "feeExpenseETranCode";
553 public static final String FEE_BY_CLASS_CODE = "feeByClassCode";
554 public static final String FEE_BY_SECURITY_CODE = "feeBySecurityCode";
555 public static final String FEE_BALANCE_TYPES_CODE = "feeBalanceTypeCode";
556 public static final String CORPUS_TO_PCT_TOLERANCE = "corpusPctTolerance";
557 public static final String FIRST_FEE_BREAK_POINT = "firstFeeBreakpoint";
558 public static final String SECOND_FEE_BREAK_POINT = "secondFeeBreakpoint";
559 public static final String THIRD_FEE_RATE = "thirdFeeRate";
560 public static final String FIRST_FEE_RATE = "firstFeeRate";
561 public static final String SECOND_FEE_RATE = "secondFeeRate";
562
563 // Tickler Constants
564 public static final String TICKLER_NUMBER = "number";
565 public static final String TICKLER_CODE = "typeCode";
566 public static final String TICKLER_FREQUENCY_CODE = "frequencyCode";
567 public static final String TICKLER_NEXT_DUE_DATE = "nextDueDate";
568 public static final String TICKLER_DETAIL = "detail";
569 public static final String TICKLER_ENTRY_DETAIL = "entryDate";
570 public static final String TICKLER_TERMINATION_DATE = "terminationDate";
571 public static final String TICKLER_ACTIVE_INDICATOR = "active";
572 public static final String TICKLER_OBJECT_ID = "objectId";
573 public static final String TICKLER_VERSION_NUMBER = "versionNumber";
574 public static final String TICKLER_SECURITIES = "securities";
575 public static final String TICKLER_TYPE_CODE = "code";
576 public static final String TICKLER_KEMID = "kemId";
577 public static final String TICKLER_SECURITYID = "securityId";
578 public static final String TICKLER_RECIPIENT_PRINCIPALID = "principalId";
579 public static final String TICKLER_LOOKUP_USER_ID_FIELD = "recipientPrincipals.contact.principalName";
580 public static final String TICKLER_LOOKUP_UNIVERSAL_USER_ID_FIELD = "recipientPrincipals.principalId";
581 public static final String TICKLER_RECIPIENT_GROUPID = "groupId";
582 public static final String TICKLER_LOOKUP_GROUP_NAME_FIELD = "groupLookup.groupName";
583 public static final String TICKLER_LOOKUP_GROUP_USER_ID_FIELD = "recipientGroups.groupId";
584 public static final String TICKLER_LOOKUP_KEMID = "kemIds.kemId";
585
586 // Transaction Line
587 public static final String TRANSACTION_LINE_DOCUMENT_NUMBER = "documentNumber";
588 public static final String TRANSACTION_LINE_TYPE_CODE = "transactionLineTypeCode";
589 public static final String TRANSACTION_LINE_NUMBER = "transactionLineNumber";
590
591 // Transaction Holding Lot Line
592 public static final String TRANSACTION_HOLDING_LOT_NUMBER = "transactionHoldingLotNumber";
593
594 // Transaction Document
595 public static final String TRANSACTION_LINE_DESCRIPTION = "transactionLineDescription";
596 public static final String TRANSACTION_DOCUMENT_NUMBER = "documentNumber";
597
598 public static final String TRANSACTION_SECURITY_DOCUMENT_NUMBER = "documentNumber";
599 public static final String TRANSACTION_SECURITY_LINE_TYPE_CODE = "securityLineTypeCode";
600
601 public static final String TRANSACTION_LINE_ENDOWMENT_TRANSACTION_CODE = "etranCode";
602 public static final String TRANSACTION_LINE_TRANSACTION_AMOUNT = "transactionAmount";
603 public static final String TRANSACTION_LINE_TRANSACTION_UNITS = "transactionUnits";
604 public static final String TRANSACTION_LINE_IP_INDICATOR_CODE = "transactionIPIndicatorCode";
605 public static final String TRANSACTION_LINE_TRANSACTION_UNIT_ADJUSTMENT_AMOUNT = "unitAdjustmentAmount";
606
607
608 public static final String TARGET_TRANSACTION_LINE_PREFIX = "newTargetTransactionLine.";
609 public static final String SOURCE_TRANSACTION_LINE_PREFIX = "newSourceTransactionLine.";
610
611 public static final String TARGET_ACCT_LINE_PREFIX = "newTargetAccountingLine.";
612 public static final String SOURCE_ACCT_LINE_PREFIX = "newSourceAccountingLine.";
613
614
615 public static final String EXISTING_SOURCE_TRANSACTION_LINE_PREFIX = "document.sourceTransactionLines";
616 public static final String EXISTING_TARGET_TRANSACTION_LINE_PREFIX = "document.targetTransactionLines";
617
618 public static final String EXISTING_SOURCE_ACCT_LINE_PREFIX = "document.sourceAccountingLines";
619 public static final String EXISTING_TARGET_ACCT_LINE_PREFIX = "document.targetAccountingLines";
620
621 public static final String TRANSACTION_SECURITY_ID = "securityID";
622 public static final String TRANSACTION_REGISTRATION_ID = "registrationCode";
623 public static final String TRANSACTION_IPINDICATOR = "transactionIPIndicatorCode";
624 public static final String TRANSACTION_SECURITY = "security";
625 public static final String TRANSACTION_REGISTRATION_CD = "registrationCodeObj";
626
627 public static final String TRANSACTION_SOURCE_SECURITY_PREFIX = "document.sourceTransactionSecurity.";
628 public static final String TRANSACTION_TARGET_SECURITY_PREFIX = "document.targetTransactionSecurity.";
629
630 public static final String HISTORY_VALUE_ADJUSTMENT_SECURITY_ID = "securityId";
631 public static final String HISTORY_VALUE_ADJUSTMENT_UNIT_VALUE = "securityUnitValue";
632 public static final String HISTORY_VALUE_ADJUSTMENT_MARKET_VALUE = "securityMarketValue";
633
634 // Holding Tax Lot Re-balance
635 public static final String HOLDING_TAX_LOT_REBAL_LOTS_TAB = "holdingTaxLots";
636 public static final String HOLDING_TAX_LOT_REBAL_INCOME_PRINCIPAL_INDICATOR = "incomePrincipalIndicator";
637 public static final String HOLDING_TAX_LOT_REBAL_REGISTRATION_CODE = "registrationCode";
638 public static final String HOLDING_TAX_LOT_REBAL_SECURITY_ID = "securityId";
639 public static final String HOLDING_TAX_LOT_REBAL_KEMID = "kemid";
640
641 // Transaction Archive/Security
642 public static final String TRANSACTION_ARCHIVE_KEM_ID = "kemid";
643
644 public static final String TRANSACTION_ARCHIVE_SECURITY_ID = "securityId";
645 public static final String TRANSACTION_ARCHIVE_INCOME_PRINCIPAL_ID = "incomePrincipalIndicatorCode";
646
647 public static final String TRANSACTION_ARCHIVE_DOCUMENT_NUMBER = "documentNumber";
648 public static final String TRANSACTION_ARCHIVE_LINE_NUMBER = "lineNumber";
649 public static final String TRANSACTION_ARCHIVE_LINE_TYPE_CODE = "lineTypeCode";
650 public static final String TRANSACTION_ARCHIVE_CORPUS_INDICATOR = "corpusIndicator";
651 public static final String TRANSACTION_ARCHIVE_SUB_TYPE_CODE = "subTypeCode";
652
653 public static final String TRANSACTION_ARCHIVE_TYPE_CODE = "typeCode";
654 public static final String TRANSACTION_ARCHIVE_POSTED_DATE = "postedDate";
655 public static final String TRANSACTION_ARCHIVE_ETRAN_CODE = "etranCode";
656
657 public static final String TRANSACTION_ARCHIVE_GREATER_AMOUNT = "greaterAmount";
658 public static final String TRANSACTION_ARCHIVE_LESS_AMOUNT = "lessAmount";
659 public static final String TRANSACTION_ARCHIVE_INCOME_PRINCIPAL_INDICATOR = "incomePrincipalIndicatorCode";
660 public static final String TRANSACTION_ARCHIVE_INCOME_CASH_AMOUNT = "incomeCashAmount";
661 public static final String TRANSACTION_ARCHIVE_PRINCIPAL_CASH_AMOUNT = "principalCashAmount";
662
663 // Endowment Accounting Line
664 public static final String ENDOWMENT_ACCOUNTING_LINE_OBJECT_CD = "financialObjectCode";
665 public static final String ENDOWMENT_ACCOUNTING_LINE_CHART_CD = "chartOfAccountsCode";
666 public static final String ENDOWMENT_ACCOUNTING_LINE_ACCT_NBR = "accountNumber";
667 public static final String ENDOWMENT_ACCOUNTING_LINE_SUBACCT_NBR = "subAccountNumber";
668 public static final String ENDOWMENT_ACCOUNTING_LINE_SUBOBJ_CD = "financialSubObjectCode";
669 public static final String ENDOWMENT_ACCOUNTING_LINE_PROJECT_CD = "projectCode";
670 public static final String ENDOWMENT_ACCOUNTING_LINE_NBR = "accountingLineNumber";
671 public static final String ENDOWMENT_ACCOUNTING_LINE_ORG_REF_ID = "organizationReferenceId";
672 public static final String ENDOWMENT_ACCOUNTING_LINE_AMOUNT = "amount";
673
674 public static final String DOCUMENT_NUMBER = "documentNumber";
675
676 // Endowment Recurring Cash Transfer
677 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_SOURCE_KEMID = "sourceKemid";
678 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_SOURCE_ETRAN_CODE = "sourceEtranCode";
679 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_ETRAN_CODE_OBJ = "etranCodeObj";
680
681 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_NEXT_PROC_DATE = "nextProcessDate";
682 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_FREQUENCY_CODE = "frequencyCode";
683 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TRANSACTION_TYPE = "transactionType";
684 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_KEMID = "targetKemid";
685 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_ETRAN_CODE = "targetEtranCode";
686 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_AMOUNT = "targetAmount";
687 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_PERCENT = "targetPercent";
688 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_USE_ETRAN_CODE = "targetUseEtranCode";
689 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_INCOME_OR_PRINCIPAL_CODE = "targetIncomeOrPrincipal";
690
691 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_COA_CODE = "targetChartOfAccountsCode";
692 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_ACCOUNT_NUMBER = "targetAccountsNumber";
693 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_OBJECT_CODE = "targetFinancialObjectCode";
694 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_FDOC_LINE_AMOUNT = "targetFdocLineAmount";
695 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_SUB_ACCOUNT_NUMBER = "targetSubAccountNumber";
696 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_SUB_OBJECT_CODE = "targetFinancialSubObjectCode";
697 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_PROJECT_CODE = "targetProjectCode";
698 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_ORG_REF_ID = "targetOrgReferenceId";
699 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_TARGET_ETRAN_CODE_OBJ = "targetEtranCodeObj";
700
701 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_KEMID_TARGET = "kemidTarget";
702 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_GL_TARGET = "glTarget";
703 public static final String ENDOWMENT_RECURRING_CASH_TRANSF_ACTIVE_INDICATOR = "active";
704
705 public static class ColumnNames {
706
707 public static class UpdateCorpus {
708 public static final String TRANSACTION_ARCHIVE_KEMID = "TRAN_KEMID";
709 public static final String TRANSACTION_CORPUS_AMT = "TRAN_CORPUS_AMT";
710 public static final String CRNT_ENDOW_CORPUS_VAL = "CRNT_CORPUS_VAL";
711 public static final String CRNT_BALANCE_KEMID = "KEMID";
712 public static final String CRNT_BALANCE_PRINCIPAL_AT_MARKET = "PRIN_AT_MARKET";
713 }
714
715 public static class GlInterfaceBatchProcessLine {
716 public static final String TRANSACTION_ARCHIVE_FDOC_NBR = "FDOC_NBR";
717 public static final String TRANSACTION_ARCHIVE_FDOC_LN_NBR = "FDOC_LN_NBR";
718 public static final String TRANSACTION_ARCHIVE_FDOC_LN_TYP_CD = "FDOC_LN_TYP_CD";
719 public static final String TRANSACTION_ARCHIVE_DOC_TYP_NM = "DOC_TYP_NM";
720 public static final String TRANSACTION_ARCHIVE_TRAN_SUB_TYP_CD = "TRAN_SUB_TYP_CD";
721 public static final String TRANSACTION_ARCHIVE_TRAN_ETRAN_CD = "TRAN_ETRAN_CD";
722 public static final String TRANSACTION_ARCHIVE_TRAN_IP_IND_CD = "TRAN_IP_IND_CD";
723 public static final String TRANSACTION_ARCHIVE_TRAN_PRIN_CSH_AMT = "TRAN_PRIN_CSH_AMT";
724 public static final String TRANSACTION_ARCHIVE_TRAN_INC_CSH_AMT = "TRAN_INC_CSH_AMT";
725 public static final String TRANSACTION_ARCHIVE_TRAN_SEC_ID = "TRAN_SEC_ID";
726 public static final String TRANSACTION_ARCHIVE_KEM_ID = "TRAN_KEMID";
727 public static final String TRANSACTION_ARCHIVE_TRAN_SEC_ETRAN_CD = "TRAN_SEC_ETRAN_CD";
728 public static final String TRANSACTION_ARCHIVE_TRAN_SEC_COST = "TRAN_SEC_COST";
729 public static final String TRANSACTION_ARCHIVE_TRAN_SEC_ST_GAIN_LOSS = "TRAN_SEC_ST_GAIN_LOSS";
730 public static final String TRANSACTION_ARCHIVE_TRAN_SEC_LT_GAIN_LOSS = "TRAN_SEC_LT_GAIN_LOSS";
731 public static final String TRANSACTION_ARCHIVE_CHRT_CD = "CHRT_CD";
732 public static final String TRANSACTION_ARCHIVE_ACCT_NBR = "ACCT_NBR";
733 public static final String TRANSACTION_ARCHIVE_OBJECT = "OBJECT";
734 }
735 }
736
737 public static final String ENDOWMENT_HIST_CASH_KEMID = "kemid";
738 public static final String ENDOWMENT_HIST_CASH_MED_ID = "monthEndDateId";
739
740 public static final String CAMPUS_CODE = "campusCode";
741 }