| Name | Description | Type | Additional information |
|---|---|---|---|
| RecordID | integer |
None. |
|
| ClientId | integer |
None. |
|
| ClientCode | string |
String length: inclusive between 0 and 20 |
|
| PolicyCode | string |
String length: inclusive between 0 and 20 |
|
| Description | string |
String length: inclusive between 0 and 50 |
|
| BaseSalaryAccessMethod | string |
String length: inclusive between 0 and 2 |
|
| DefFamSize | integer |
None. |
|
| DefFilingStatus | integer |
None. |
|
| DefFamSizeatHost | integer |
None. |
|
| Defdependents | integer |
None. |
|
| DefExemptions | integer |
None. |
|
| DefGSi | decimal number |
None. |
|
| DefGSISpendNorm | decimal number |
None. |
|
| DefHomeHousingNorm | decimal number |
None. |
|
| DefHousingType | string |
String length: inclusive between 0 and 10 |
|
| DefNumofBed | integer |
None. |
|
| DefFXrate | decimal number |
None. |
|
| DefHomecountry | string |
String length: inclusive between 0 and 5 |
|
| DefHostcountry | string |
String length: inclusive between 0 and 5 |
|
| DefHostHousingCalcType | string |
String length: inclusive between 0 and 5 |
|
| DefHostSelectionType | string |
String length: inclusive between 0 and 5 |
|
| DefHostHouseCost | decimal number |
None. |
|
| DefHypoTaxFactor | decimal number |
None. |
|
| DefCompTypes | string |
String length: inclusive between 0 and 512 |
|
| DefClassificationType | string |
String length: inclusive between 0 and 512 |
|
| CalcHypo | string |
String length: inclusive between 0 and 2 |
|
| CalcFedHypo | string |
String length: inclusive between 0 and 2 |
|
| calcSocialHypo | string |
String length: inclusive between 0 and 2 |
|
| DefReport | integer |
None. |
|
| AddedOn | date |
None. |
|
| AddedBy | string |
String length: inclusive between 0 and 50 |
|
| LastModifiedOn | date |
None. |
|
| LastModifiedBy | string |
String length: inclusive between 0 and 50 |
|
| DefGSAllowance | decimal number |
None. |
|
| CalcGSSPendNorm | string |
String length: inclusive between 0 and 2 |
|
| CalcGSAllowance | string |
String length: inclusive between 0 and 2 |
|
| CalcHomeHouseNorm | string |
String length: inclusive between 0 and 2 |
|
| CalcForExRate | string |
String length: inclusive between 0 and 2 |
|
| CalcForHouseCost | string |
String length: inclusive between 0 and 2 |
|
| GSSpendNormFloor | decimal number |
None. |
|
| GSSpendNormCeiling | decimal number |
None. |
|
| GSAllowFloor | decimal number |
None. |
|
| GSAllowCeiling | decimal number |
None. |
|
| HHNormFloor | decimal number |
None. |
|
| HHNormCeiling | decimal number |
None. |
|
| FHCostFloor | decimal number |
None. |
|
| FHCostCeiling | decimal number |
None. |
|
| CalcHypoIfBSZero | string |
String length: inclusive between 0 and 2 |
|
| HypoTaxoptFactor | decimal number |
None. |
|
| PayrollParamOption | string |
String length: inclusive between 0 and 2 |
|
| DefHomeLocID | integer |
None. |
|
| DefHomeLocCode | string |
String length: inclusive between 0 and 100 |
|
| DefHomeCurrency | string |
String length: inclusive between 0 and 10 |
|
| DefHostLocID | integer |
None. |
|
| DefHostLocCode | string |
String length: inclusive between 0 and 100 |
|
| DefHostCurrency | string |
String length: inclusive between 0 and 10 |
|
| DefBSFrequency | integer |
None. |
|
| DefPIFrequency | integer |
None. |
|
| PolicyValFrequency | integer |
None. |
|
| HypoIterateTT | string |
String length: inclusive between 0 and 2 |
|
| FXRateBasis | byte |
None. |
|
| FXRateProvider | string |
String length: inclusive between 0 and 20 |
|
| PolStatus | string |
String length: inclusive between 0 and 2 |
|
| FirstColumnOption | byte |
None. |
|
| DefBSHostFrequency | byte |
None. |
|
| DefPIHostFrequency | byte |
None. |
|
| defCurrency | string |
String length: inclusive between 0 and 10 |
|
| defItemizeType | byte |
None. |
|
| defItemizeAmtPct | decimal number |
None. |
|
| defItemizeAmtorPct | string |
String length: inclusive between 0 and 5 |
|
| EmailTemplate | string |
String length: inclusive between 0 and 2000 |
|
| EmailToUse | string |
String length: inclusive between 0 and 2000 |
|
| EmailCC | string |
String length: inclusive between 0 and 2000 |
|
| EmailBCC | string |
String length: inclusive between 0 and 2000 |
|
| NetToNet | byte |
None. |
|
| NtoNSalModOnly | byte |
None. |
|
| NtoNMethod | string |
String length: inclusive between 0 and 60 |
|
| Capped_Salary | decimal number |
None. |
|
| Capped_SalaryTable | string |
String length: inclusive between 0 and 100 |
|
| ColOptPPAnn | byte |
None. |
|
| ColOptCurrPrev | byte |
None. |
|
| ID | integer |
None. |