Table: JTF_AUTH_PRINCIPALS_B

Product:	JTF - CRM Foundation
Description:	A principal will be a user or a role. If the principal is a user then the column IS_USER_FLAG is set to 1 and USER_ID points to a user in FND_USER. We will later use application id to stripe the data for hosting purposes.
Implementation/DBA Data:	JTF.JTF_AUTH_PRINCIPALS_B

Primary Key: JTF_AUTH_PRINCIPAL_B_PK

1. JTF_AUTH_PRINCIPAL_ID

Primary Key: JTF_AUTH_PRINCIPAL_UK1

1. PRINCIPAL_NAME

Primary Key: JTF_AUTH_PRINCIPAL_UK2

1. PRINCIPAL_DESC_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
JTF_AUTH_ACCT_ROLE_MAPS		JTF_AUTH_PRINCIPALS_B	JTF_AUTH_ACCT_ROLE_MAPS.JTF_AUTH_PRINCIPAL_ID
JTF_AUTH_PRINCIPALS_TL		JTF_AUTH_PRINCIPALS_B	JTF_AUTH_PRINCIPALS_TL.PRINCIPAL_DESC_ID
JTF_AUTH_PRINCIPAL_MAPS		JTF_AUTH_PRINCIPALS_B	JTF_AUTH_PRINCIPAL_MAPS.JTF_AUTH_PRINCIPAL_ID
JTF_AUTH_PRINCIPAL_MAPS		JTF_AUTH_PRINCIPALS_B	JTF_AUTH_PRINCIPAL_MAPS.JTF_AUTH_PARENT_PRINCIPAL_ID
JTF_AUTH_READ_PERMS		JTF_AUTH_PRINCIPALS_B	JTF_AUTH_READ_PERMS.JTF_AUTH_PRINCIPAL_ID
JTF_AUTH_ROLE_PERMS		JTF_AUTH_PRINCIPALS_B	JTF_AUTH_ROLE_PERMS.JTF_AUTH_PRINCIPAL_ID
JTF_DAC_ROLE_PERM_CRIT		JTF_AUTH_PRINCIPALS_B	JTF_DAC_ROLE_PERM_CRIT.JTF_AUTH_PRINCIPAL_ID
JTF_UM_SUBSCRIPTIONS_B		JTF_AUTH_PRINCIPALS_B	JTF_UM_SUBSCRIPTIONS_B.AUTH_DELEGATION_ROLE_ID
JTF_UM_SUBSCRIPTION_ROLE		JTF_AUTH_PRINCIPALS_B	JTF_UM_SUBSCRIPTION_ROLE.PRINCIPAL_NAME
JTF_UM_USERTYPE_ROLE		JTF_AUTH_PRINCIPALS_B	JTF_UM_USERTYPE_ROLE.PRINCIPAL_NAME
PV_ATTR_PRINCIPALS		JTF_AUTH_PRINCIPALS_B	PV_ATTR_PRINCIPALS.JTF_AUTH_PRINCIPAL_ID