SEC_COMP_REGDTL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: SEC_PNLGRP_VW |
| 2 | RECNAME_DETAIL |
Character(15) | VARCHAR2(15) NOT NULL |
Detail Record
Prompt Table: COMP_REC_LVN_VW |
| 3 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive Default Value: A |
| 4 | RECNAME_SEC | Character(15) | VARCHAR2(15) NOT NULL |
Security Edit Table
Prompt Table: RECDEFN_VW |
| 5 | EDIT_GROUP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Edit Table Set
Prompt Table: SEC_EDITTBL_GRP |
| 6 | SEC_ACCESS_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
When user has partial access
D=Deny Access G=Grant Access X=Default from Higher Level Default Value: X |
| 7 | SEC_DISTRIB_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Secure Dist Code
Y/N Table Edit Default Value: N |