OPRCLASSPrompt Table: OPRCLASS_VW
Prompt Table: LED_GRP_ALL_VW
D=Detail Ledger
K=Commitment Control Ledger
S=Summary Ledger
SEC_GRP_CLS_VW(SQL View) |
Index Back |
|---|---|
Ledger Group Security View |
| select distinct oprclass ,ledger_group ,ledger_type from PS_SEC_LEDGER_CLS where ledger_type = 'D' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRCLASS |
Character(30) | VARCHAR2(30) NOT NULL |
Operator Class
Prompt Table: OPRCLASS_VW |
| 2 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table: LED_GRP_ALL_VW |
| 3 | LEDGER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Ledger Type
D=Detail Ledger K=Commitment Control Ledger S=Summary Ledger |