Bewerken: Competence

Sectie: Properties

Reden:

## Properties

| Property | Type | Kolom | Width | Nullable | Default |
|----------|------|-------|-------|----------|---------|
| Id | UltimoString | CMPID | 6 | false |  |
| Context | Context | CMPCONTEXT |  | false | 1 |
| DataProvider | UltimoString | CMPDATAPROVIDER | 50 | true |  |
| Description | UltimoString | CMPDESCR | 200 | true |  |
| Exported | Boolean | CMPEXPORTED |  | false | 0 |
| ExternalId | UltimoString | CMPEXTERNALID | 50 | true |  |
| ExternalStatus | UltimoString | CMPEXTERNALSTATUS | 50 | true |  |
| ProviderMutationDate | DateTime? | CMPPROVIDERMUTDATE |  | true |  |
| RecordCreateDate | DateTime? | CMPRECCREATEDATE |  | true | SYSDATETIME |
| RemarkText | UltimoString | CMPREMARKTEXT |  | true |  |
| Status | Status | CMPRECSTATUS |  | false | 1 |
| StatusApprovedDate | DateTime? | CMPAPPROVEDDATE |  | true |  |
| StatusApprovedEmployee | Employee | CMPAPPROVEDEMPID |  | true |  |
| StatusCreatedDate | DateTime? | CMPCREATEDDATE |  | true | SYSDATETIME |
| StatusCreatedEmployee | Employee | CMPCREATEDEMPID |  | true | USERID |
| StatusExpiredDate | DateTime? | CMPEXPIREDDATE |  | true |  |
| StatusExpiredEmployee | Employee | CMPEXPIREDEMPID |  | true |  |
| SystemCompany | Company | CMPCOMPID |  | false |  |
| TransferNextTime | Boolean | CMPTRANSFERNEXTTIME |  | false | 0 |