MCFEM_ATT_AUTH (SQL Table)	Index Back
Attachment Authorization Tbl Contains authorization info on who is allowed to access the attachment repository.

MCFEM_ATT_AUTH

(SQL Table)

Attachment Authorization Tbl

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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)

3 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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MCF_EMAIL_ID	Number(16,0)	DECIMAL(16) NOT NULL	Email Id
2	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)
3	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
4	MCF_AUTH_ACL	Character(16)	VARCHAR2(16) NOT NULL	Acces control list for accesing attachments from the repository