MCFEM_ATT_AUTH - Attachment Authorization Tbl

MCFEM_ATT_AUTH	index back
Attachment Authorization Tbl

Contains authorization info on who is allowed to access the attachment repository.

PeopleSoft Field Name Field Type Column Type Description

MCF_EMAIL_ID Number(16,0) DECIMAL(16) NOT NULL Email Id

MCF_AUTH_NAME Character(30) VARCHAR2(30) NOT NULL name of the authorization entity - oprID for type =2 (user) and rolename for type =3 (role)

MCF_AUTH_TYPE Character(3) VARCHAR2(3) NOT NULL Describes the type of authorization i.e. user-based(2) or role-based(3).
2=User
3=Role

MCF_AUTH_ACL Character(16) VARCHAR2(16) NOT NULL Acces control list for accesing attachments from the repository

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

PeopleSoft Field Name	Field Type	Column Type	Description
MCF_EMAIL_ID	Number(16,0)	DECIMAL(16) NOT NULL	Email Id
MCF_AUTH_NAME	Character(30)	VARCHAR2(30) NOT NULL	name of the authorization entity - oprID for type =2 (user) and rolename for type =3 (role)
MCF_AUTH_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Describes the type of authorization i.e. user-based(2) or role-based(3). 2=User 3=Role
MCF_AUTH_ACL	Character(16)	VARCHAR2(16) NOT NULL	Acces control list for accesing attachments from the repository