Table 208. Request Preliminary Rating Fields
Name
|
XML Tag
|
Data Type
|
Length
|
Req.
|
Notes
|
FINS Group Policy
|
FinsGroupPolicy
|
|
|
|
Primary integration component.
User key field: Policy Number.
|
Effective Date
|
EffectiveDate
|
DTYPE_TEXT
|
7
|
|
|
End Date
|
EndDate
|
DTYPE_TEXT
|
7
|
|
|
Group Name
|
GroupName
|
DTYPE_TEXT
|
100
|
|
Used for picking a related entity.
|
Policy Number
|
PolicyNumber
|
DTYPE_TEXT
|
100
|
|
User key field for Fins Group Policy.
|
Premium
|
Premium
|
DTYPE_TEXT
|
22
|
|
|
Premium Currency Code
|
PremiumCurrencyCode
|
DTYPE_TEXT
|
20
|
|
Used for picking a related entity.
|
Purchase Date
|
PurchaseDate
|
DTYPE_TEXT
|
7
|
|
|
Renewal Date
|
RenewalDate
|
DTYPE_TEXT
|
7
|
|
|
Source Policy Id
|
SourcePolicyId
|
DTYPE_ID
|
15
|
|
|
State
|
State
|
DTYPE_TEXT
|
10
|
|
Bound by STATE_ABBREV LOV.
|
Type
|
Type
|
DTYPE_TEXT
|
30
|
|
|
FINS Group Company Census
|
FinsGroupCompanyCensus
|
|
|
|
Integration component.
User key field: Id.
|
Census Date
|
CensusDate
|
DTYPE_DATETIME
|
7
|
|
|
Census Group Count
|
CensusGroupCount
|
DTYPE_NUMBER
|
22
|
|
|
Census Name
|
CensusName
|
DTYPE_TEXT
|
50
|
|
|
Id
|
Id
|
DTYPE_ID
|
30
|
|
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.
User key field for Fins Group Company Census.
|
FINS Group Policy Item
|
FinsGroupPolicyItem
|
|
|
|
Integration component.
No user key fields.
|
Description
|
Description
|
DTYPE_TEXT
|
250
|
|
|
Enrollable Flag
|
Enrollable
|
DTYPE_TEXT
|
1
|
|
|
Id
|
Id
|
DTYPE_ID
|
30
|
|
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.
User key field for Fins Group Policy Item.
|
Name
|
OptionName
|
DTYPE_TEXT
|
50
|
|
|
Outline Number
|
OutlineNumber
|
DTYPE_TEXT
|
30
|
|
|
Parent Policy Item Id
|
ParentPolicyItemId
|
DTYPE_ID
|
15
|
|
|
Product
|
Product
|
DTYPE_TEXT
|
100
|
|
Used for picking a related entity.
|
Sold Flag
|
Sold
|
DTYPE_TEXT
|
1
|
|
|
Status
|
Status
|
DTYPE_TEXT
|
30
|
|
Bound by FINS_GROUP_ITEM_STATUS LOV.
|
FINS Health Policy Product
|
FinsHealthPolicyProduct
|
|
|
|
Integration component.
User key field: Product Id via Item.
|
Account Name
|
Division
|
DTYPE_TEXT
|
100
|
|
|
Asset Item Name
|
OptionName
|
DTYPE_TEXT
|
50
|
|
Used for picking a related entity. User key field for Fins Health Policy Product.
|
Class Name
|
Class
|
DTYPE_TEXT
|
50
|
|
Used for picking a related entity.
|
Min Participation Percent
|
MinParticipationPercent
|
DTYPE_NUMBER
|
22
|
|
|
Product Id via Item
|
Product
|
DTYPE_ID
|
15
|
|
User key field for Fins Health Policy Product.
|
Waiting Period
|
WaitingPeriod
|
DTYPE_TEXT
|
20
|
|
Bound by FINS_WAITING_PERIOD.
|
FINS Group Company Census Aggregate Detail
|
FinsGroupCompanyAggregateDetail
|
|
Integration component.
User key field: Detail Id.
|
Age Band
|
AgeBand
|
DTYPE_TEXT
|
50
|
|
|
Aggregate Count
|
AggregateCount
|
DTYPE_NUMBER
|
22
|
|
|
Class Ref Num
|
ClassRefNum
|
DTYPE_TEXT
|
30
|
|
|
Detail Id
|
DetailId
|
DTYPE_NUMBER
|
22
|
|
User key field for FINS Group Company Census Aggregate Detail.
|
Division
|
Division
|
DTYPE_TEXT
|
50
|
|
|
Sex
|
Sex
|
DTYPE_TEXT
|
1
|
|
Bound by SEX_MFLOV.
|
FINS Group Company Census Detail
|
FINSGroupCompany CensusDetail
|
|
|
|
Integration component.
User key field: Detail Id.
|
Class Ref Num
|
ClassRefNum
|
DTYPE_TEXT
|
30
|
|
|
Date Of Birth
|
DateOfBirth
|
DTYPE_DATETIME
|
7
|
|
|
Date of Hire
|
DateofHire
|
DTYPE_DATETIME
|
7
|
|
|
Detail Id
|
DetailId
|
DTYPE_NUMBER
|
22
|
|
User key field for Fins Group Company Census Detail.
|
Name
|
Name
|
DTYPE_TEXT
|
100
|
|
|
Sex
|
Sex
|
DTYPE_TEXT
|
1
|
|
Bound by SEX_MF LOV.
|
FINS Group Policy Holding for Item
|
Class
|
|
|
|
Integration component.
User key field: Id.
|
Account Name
|
DivisionName
|
DTYPE_TEXT
|
100
|
|
|
Account Site
|
DivisionSite
|
DTYPE_TEXT
|
50
|
|
|
Class Name
|
ClassName
|
DTYPE_TEXT
|
50
|
|
Used for picking a related entity.
|
Id
|
Id
|
DTYPE_ID
|
30
|
|
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.
User key field for Fins Group Policy Holding for Items.
|
Class Reference Number
|
ClassReferenceNumber
|
DTYPE_TEXT
|
30
|
|
|
Min Participation Percent
|
MinParticipationPercent
|
DTYPE_NUMBER
|
22
|
|
|
Waiting Period
|
WaitingPeriod
|
DTYPE_TEXT
|
20
|
|
Bound by FINS_WAITING_PERIOD LOV.
|
FINS Group Policy Item XA
|
Attribute
|
|
|
|
Integration component.
User key field: Name.
|
Display Name
|
DisplayName
|
DTYPE_TEXT
|
100
|
|
|
Display To User
|
DisplayToUser
|
DTYPE_TEXT
|
1
|
|
|
Name
|
Name
|
DTYPE_TEXT
|
75
|
|
User key field for Fins Group Policy Item XA.
|
FINS Group Policy Rate Bands
|
FinsGroupPolicyRateBands
|
|
Integration component.
User key field: Id.
|
Bid Rate Amt
|
BidRate
|
DTYPE_TEXT
|
22
|
|
|
Employer Contri Amt
|
EmployerContribution
|
DTYPE_TEXT
|
22
|
|
|
Final Rate Amt
|
FinalRate
|
DTYPE_TEXT
|
22
|
|
|
Id
|
Id
|
DTYPE_ID
|
30
|
|
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.
User key field for Fins Group Policy Rate Bands.
|
Manual Rate Amt
|
ManualRate
|
DTYPE_TEXT
|
22
|
|
|
Payroll Deductible Amt
|
PayrollDeductibleAmt
|
DTYPE_TEXT
|
22
|
|
|
Rate Band Name
|
RateBandName
|
DTYPE_TEXT
|
30
|
|
Used for picking a related entity.
|
Sold Rate Amt
|
SoldRate
|
DTYPE_TEXT
|
22
|
|
|