SEC_FIELDS_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: SEC_CF_VW |
| 2 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: SECREC_USER_VW |
| 3 | RECNAME_2 | Character(15) | VARCHAR2(15) NOT NULL |
Record 2 Name
Prompt Table: SECREC_ROLE_VW |
| 4 | RECNAME_3 | Character(15) | VARCHAR2(15) NOT NULL |
Rename
Prompt Table: SECREC_PERM_VW |
| 5 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive Default Value: I |
| 6 | SEC_IUAFFIL_CF | Character(1) | VARCHAR2(1) NOT NULL |
Secure Affiliate Chartfield
Y/N Table Edit Default Value: N |
| 7 | CF_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Chartfield Type - Use specificaly for Chartfield Template.
A=Affiliate C=Currency Code D=Deleted Chartfield F=Fully Configurable P=Partially Configurable S=Statistic Code X=Product Specific |
| 8 | SEC_EDITTBL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Override Prompt List Security
Y/N Table Edit Default Value: N |
| 9 | HIDDEN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Hidden Flag
Y/N Table Edit Default Value: N |
| 10 | RECNAME_INQ_VW | Character(15) | VARCHAR2(15) NOT NULL |
Inquiry View
Prompt Table: SECVREC_USER_VW |
| 11 | RECNAME_INQ_VW2 | Character(15) | VARCHAR2(15) NOT NULL |
Inquiry View
Prompt Table: SECVREC_ROLE_VW |
| 12 | RECNAME_INQ_VW3 | Character(15) | VARCHAR2(15) NOT NULL |
Inquiry View
Prompt Table: SECVREC_PERM_VW |
| 13 | VIEW_OPR_SECURITY | Character(15) | VARCHAR2(15) NOT NULL | User ID Security View |
| 14 | VIEW_ROLE_SECURITY | Character(15) | VARCHAR2(15) NOT NULL | Role Security View |
| 15 | VIEW_CLS_SECURITY | Character(15) | VARCHAR2(15) NOT NULL | Permission List Security View |