hbacct_raw

Pipelined Data Sets > SilverLake > hbacct_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
hbcid	NetTeller ID \| DEC(12,0)	NULLABLE	INTEGER	12
hbappl	Application \| CHAR(1)	NULLABLE	STRING	1
hbact_num_	Account number \| DEC(16,0)	NULLABLE	INTEGER	16
hbatyp	Account type \| CHAR(1)	NULLABLE	STRING	1
hbsudo	Pseudo account number \| CHAR(20)	NULLABLE	STRING	20
rfcif_num_	Ref. CIF number \| CHAR(7)	NULLABLE	STRING	7
rfact_num_	Ref. Account number \| DEC(16,0)	NULLABLE	INTEGER	16
rfatyp	Ref. Account type \| CHAR(1)	NULLABLE	STRING	1
rfrela	Ref. relationship \| CHAR(5)	NULLABLE	STRING	5
hbira	IRA indicator \| CHAR(1)	NULLABLE	STRING	1
sortac	Sort order \| DEC(3,0)	NULLABLE	INTEGER	3
stopaa	Add stops AA counter \| DEC(3,0)	NULLABLE	INTEGER	3
stophc	Add stops hard charge \| DEC(5,2)	NULLABLE	FLOAT	5.2
tranaa	Transfer AA counter \| DEC(3,0)	NULLABLE	INTEGER	3
tranhc	Transfer hard charge \| DEC(5,2)	NULLABLE	FLOAT	5.2
stmtaa	Demand stmt AA counter \| DEC(3,0)	NULLABLE	INTEGER	3
stmthc	Demand stmt hard charge \| DEC(5,2)	NULLABLE	FLOAT	5.2
whenhc	When to hard charge \| CHAR(1)	NULLABLE	STRING	1
allowp	Allow principal \| CHAR(1)	NULLABLE	STRING	1
allowi	Allow interest \| CHAR(1)	NULLABLE	STRING	1
opts	Sorted options to use \| CHAR(36)	NULLABLE	STRING	36

Have a Question?

Have a how-to question? Seeing a weird error? Get help on StackOverflow.
Register for the Developer Office Hours where we answer technical Q&A from the audience.

Please ignore this field

Did this page help you?

Last updated Wed Mar 4 2026