DocumentRecords
DocumentRecords
Columns
Name | Type | Description |
DocumentsOfRecordId [KEY] | Long | Surrogate identifier for the record. Applicable to existing records only. |
DocumentTypeId | Long | Unique identifier for the document type. |
SystemDocumentType | String | System-generated name that uniquely identifies the document type. |
DocumentType | String | Document type for the document record. |
Country | String | Name of the country, if the document type is country specific. |
CategoryCode | String | Category for the document type. |
SubCategoryCode | String | Subcategory code for the document type. |
PersonId | Long | Unique identifier for the person. |
PersonNumber | String | Person number of the person the document record is for. |
ListName | String | Name of the person the document record is for. |
DisplayName | String | Display name of the person the document record is for. |
FullName | String | Full name of the person the document record is for. |
DocumentCode | String | Unique code that identifies the document record for the person and document type. |
DocumentName | String | Name for the document record. Used to differentiate records when multiple documents are added for the same document type. |
DocumentNumber | String | Number that legally identifies the document. |
DateFrom | Date | Date from which the document is valid. |
DateTo | Date | Last date up to which the document is valid. |
IssuingAuthority | String | Name of the issuing authority. |
IssuingCountryName | String | Name of the country that issued the document. |
IssuedDate | Date | Date on which the document was issued. |
IssuingLocation | String | Location at which the document was issued. |
Comments | String | Comments pertaining to the document record. |
Publish | String | Option to determine whether or not to publish the document record on a specific date. |
PublishDate | Date | Date on which the document was published. |
RelatedObjectId | Long | Unique identifier of the related object. |
RelatedObjectIdColumn | String | Column details of the related object identifier. |
RelatedObjectName | String | Name of the related object. |
CreatedBy | String | Name of the user who created the document. |
CreationDate | Datetime | Date on which the document record was created. |
LastUpdatedBy | String | Name of the user who last updated the document. |
LastUpdateDate | Datetime | Date on which the document record was last updated. |
AssignmentId | Long | Assignment Identifier of the person assignment. |
AssignmentNumber | String | Assignment Number of the person assignment. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Finder | String | finder |