cdplan_raw

Core Schemas > Silverlake > cdplan_raw

Column name	Description	Mode	Type	Length
__op	Contains the operation type. Values are I for insert, U for update, D for delete.	REQUIRED	STRING
__op_ts	operation timestamp added by export code	REQUIRED	TIMESTAMP
__uid	The Unique ID of this entry. Data, UUID, or GUID	REQUIRED	STRING
__ver	Mapping and Schema Version	REQUIRED	INTEGER
icifno	CIF Number \| CHAR(7)	NULLABLE	STRING	7
plan	IRA plan Code \| CHAR(3)	NULLABLE	STRING	3
isname	Short Name \| CHAR(20)	NULLABLE	STRING	20
icifac	Lead Acct# \| DEC(16,0)	NULLABLE	INTEGER	16
dob	Date of Birth \| DEC(8,0)	NULLABLE	INTEGER	8
dod	Date of Death \| DEC(8,0)	NULLABLE	INTEGER	8
domd	Date of Mand Dist \| DEC(8,0)	NULLABLE	INTEGER	8
feecod	Fee Code \| CHAR(1)	NULLABLE	STRING	1
qrpno	QRP Plan Number \| CHAR(16)	NULLABLE	STRING	16
qrpcif	QRP CIF Number \| CHAR(7)	NULLABLE	STRING	7
dobd	Date of Beg. Dist \| DEC(8,0)	NULLABLE	INTEGER	8
beglif	Beg Life Expect \| DEC(5,3)	NULLABLE	FLOAT	5.3
discal	Dist Calc Code \| CHAR(1)	NULLABLE	STRING	1
dissta	Dist Status \| CHAR(1)	NULLABLE	STRING	1
spousl	Spousal IRA \| CHAR(1)	NULLABLE	STRING	1
dismet	Dist Method \| CHAR(1)	NULLABLE	STRING	1
dismtb	Benficiary Dist Method \| CHAR(1)	NULLABLE	STRING	1
disday	Day of Month For Dist \| DEC(2,0)	NULLABLE	INTEGER	2
dond	Date of Next Dist \| DEC(8,0)	NULLABLE	INTEGER	8
dold	Date of Last Dist \| DEC(8,0)	NULLABLE	INTEGER	8
distrm	Dist Term \| DEC(3,0)	NULLABLE	INTEGER	3
distcd	Dist Term Code \| CHAR(1)	NULLABLE	STRING	1
depact	Deposit Acct# \| DEC(16,0)	NULLABLE	INTEGER	16
deptyp	Deposit Type \| CHAR(1)	NULLABLE	STRING	1
disamt	Dist Amount \| DEC(11,2)	NULLABLE	FLOAT	11.2
lstdst	Last Amount Distributed \| DEC(11,2)	NULLABLE	FLOAT	11.2
plsint	Plus Interest \| CHAR(1)	NULLABLE	STRING	1
age	Age at 12/31 \| DEC(3,0)	NULLABLE	INTEGER	3
hasout	Outplaced IRAs \| CHAR(1)	NULLABLE	STRING	1
mindis	Minimum Dist \| DEC(11,2)	NULLABLE	FLOAT	11.2
inpdt6	Date Input \| DEC(6,0)	NULLABLE	INTEGER	6
inpdt7	Date Input \| DEC(7,0)	NULLABLE	INTEGER	7
cnvrt6	Conversion Date \| DEC(6,0)	NULLABLE	INTEGER	6
cnvrt7	Conversion Date \| DEC(7,0)	NULLABLE	INTEGER	7
frstd6	Date First Deposit \| DEC(6,0)	NULLABLE	INTEGER	6
frstd7	Date First Deposit \| DEC(7,0)	NULLABLE	INTEGER	7
plndt6	Plan established date \| DEC(6,0)	NULLABLE	INTEGER	6
plndt7	Plan established date \| DEC(7,0)	NULLABLE	INTEGER	7
empcif	Employer CIF Number \| CHAR(7)	NULLABLE	STRING	7
fixwhf	Fixed W/H Fed \| DEC(11,2)	NULLABLE	FLOAT	11.2
fixwhs	Fixed W/H State \| DEC(11,2)	NULLABLE	FLOAT	11.2
fxpwhf	DISTRIBUTION % FOR FD WH \| DEC(9,8)	NULLABLE	FLOAT	9.8
fxpwhs	DISTRIBUTION % FOR ST WH \| DEC(9,8)	NULLABLE	FLOAT	9.8
distrn	Dist Tran Code \| DEC(3,0)	NULLABLE	INTEGER	3
befown	Benef. Original Owner \| CHAR(30)	NULLABLE	STRING	30
doob	Date of Birth Orig Owner \| DEC(8,0)	NULLABLE	INTEGER	8
disord	Distribution order \| CHAR(2)	NULLABLE	STRING	2
audist	AUTO DISTRIBUTION \| CHAR(1)	NULLABLE	STRING	1
audlay	AUTO DELAY 1ST DIST \| CHAR(1)	NULLABLE	STRING	1
aurclc	AUTO RECALCULATE \| CHAR(1)	NULLABLE	STRING	1
aurdce	AUTO REDUCE DISTRIBUTION \| CHAR(1)	NULLABLE	STRING	1
actsts	Status \| DEC(1,0)	NULLABLE	INTEGER	1
actinm	Individual Name \| CHAR(22)	NULLABLE	STRING	22
accact	Credit Account Number \| CHAR(17)	NULLABLE	STRING	17
accbnk	Credit Bank Number \| DEC(9,0)	NULLABLE	INTEGER	9
acctc	Credit Tran Code \| DEC(2,0)	NULLABLE	INTEGER	2
actpns	Send Prenotice \| CHAR(1)	NULLABLE	STRING	1
actcom	Company Name \| CHAR(16)	NULLABLE	STRING	16
actcdd	Company Discretionary \| CHAR(20)	NULLABLE	STRING	20
actcid	Company ID \| CHAR(10)	NULLABLE	STRING	10
actsec	Standard Entry Class \| CHAR(3)	NULLABLE	STRING	3
actced	Company Entry Desc \| CHAR(10)	NULLABLE	STRING	10
dood	Date of Death Orig Owner \| DEC(8,0)	NULLABLE	INTEGER	8
rqmind	Req Min Dist Amt \| DEC(11,2)	NULLABLE	FLOAT	11.2
rqerr	Req MDA error \| CHAR(1)	NULLABLE	STRING	1
rqovrd	Spousal Benf AgeOverride \| CHAR(1)	NULLABLE	STRING	1
rqsngl	Spousal Benf Single Life \| CHAR(1)	NULLABLE	STRING	1
rqsole	Sole Spousal Beneficiary \| CHAR(1)	NULLABLE	STRING	1
waived	Waive Mandatory dist \| CHAR(1)	NULLABLE	STRING	1
dthdst	Death Distributed \| CHAR(1)	NULLABLE	STRING	1
dthds6	Distribution Date \| DEC(6,0)	NULLABLE	INTEGER	6
dthds7	Distribution Date \| DEC(7,0)	NULLABLE	INTEGER	7

Last updated Thu Dec 12 2024