FIELD_LEVELB=Business Unit Security
C=Pay Cycle Security
I=Planning Instance Security
K=Book Security
L=Ledger Security
P=Project Security
S=SetID Security
EDITTABLESEC_VEDITTB2_VW(SQL View) |
Index Back |
|---|---|
Prompt Edit ViewPrompt Edit View |
| SELECT DISTINCT FIELD_LEVEL , EDITTABLE FROM PS_SEC_VIEWS_LOG WHERE EDITTABLE <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELD_LEVEL |
Character(1) | VARCHAR2(1) NOT NULL |
Secured Field Type
B=Business Unit Security C=Pay Cycle Security I=Planning Instance Security K=Book Security L=Ledger Security P=Project Security S=SetID Security |
| 2 | EDITTABLE |
Character(15) | VARCHAR2(15) NOT NULL | Edit Table |