Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
PapiUserOid | BIGINT | NOT NULL | API user Object ID |
PapiLoginUserName | varchar(256) | NOT NULL | Login User name |
CreationDateTime | datetime | NOT NULL | Creation Date Time |
LastAccessDateTime | datetime | NOT NULL | Last Access Date Time |
PapiUserIdentityProviderURI | varchar(256) | NULL | IdentityProvider URI(from the oAuth token) |
PapiUserIdentityProviderGUID | varchar(36) | NOT NULL | unique Identifier for the User Identity provider |
PapiUserFederatedPrincipalAlias | varchar(256) | NOT NULL | Identifier for the portal user and the Identity provider.(From oAuth token and from HL7 fields PID.3.1 for patient user and NK1.33.1 for proxy user). FPA e.g.: "URN:CERNER:IDENTITY-FEDERATION:REALM:49F17659-891C-42C9-AE26-D6AE7826F62D:PRINCIPAL:38509e38-2d69-4109-ab24-08ca19ea4a65". Format => URN:CERNER:IDENTITY-FEDERATION:REALM::PRINCIPAL: |
LastCngDTime | datetime | NOT NULL | UTC time |