portfolio_raw
Pipelined Data Sets
>
Symitar
>
portfolio_raw
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| institutionid | This field stores the JH Platform institution identifier | REQUIRED | STRING | |
| eventtime | Internal use only | NULLABLE | INTEGER | |
| sourcetype | Internal use only; SSDB field | NULLABLE | STRING | |
| operation | Internal use only; SSDB field | NULLABLE | STRING | |
| extractdate | Internal use only | NULLABLE | DATE | |
| processdatetime | Internal use only; SSDB field | NULLABLE | TIMESTAMP | |
| portfoliouuid | This field stores a JH Platform unique identifier for a portfolio | NULLABLE | STRING | |
| accountuuid | This field stores a JH Platform unique identifier for an account | NULLABLE | STRING | |
| accountnumber | This field stores the Symitar account number (membership account number) | NULLABLE | STRING | |
| portfoliokey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| accountkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| symdate | Internal use only; SSDB field | NULLABLE | INTEGER | |
| systemcreatedatetime | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odscreatedatetime | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sym | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odsdeleteflag | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odskey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| id | This field stores a credit union-defined ID to identify the Portfolio record | NULLABLE | STRING | |
| fmlastdate | This field stores the last date file maintenance was performed on the Portfolio record | NULLABLE | DATE | |
| closedate | This field stores the date the Portfolio record was closed | NULLABLE | DATE | |
| notepurgedate | This field stores the date when you purged the Note records under the Portfolio record | NULLABLE | DATE | |
| description | This field stores the credit union-defined field and typically contains a member's name or other identifying information | NULLABLE | STRING | |
| recordchangedate | The system stores the system date in this field when you create, change, or save the Portfolio record. Sometimes the system updates this field because the record was saved, even though there may not be any actual changes in the record | NULLABLE | DATE |
Have a Question?
- Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
- Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.
Did this page help you?
Last updated Tue Sep 15 2026