KSEC_EVENTA=Active
I=Inactive
Default Value: I
Default Value: 1
N=Specify Number of Combinations
Y=Use All Combinations in Scroll
Default Value: N
KSEC_EVENTS_VW(SQL View) |
Index Back |
|---|
| SELECT KSEC_EVENT , DESCR , ACTIVE_STATUS , KSEC_NOCOMBO , KSEC_ALL_COMBO FROM PS_KSEC_EVENTS A WHERE A.KSEC_EVENT NOT IN ('BUDG_DT','BYPASS') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | KSEC_EVENT |
Character(8) | VARCHAR2(8) NOT NULL | Security Event |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | ACTIVE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Template Status
A=Active I=Inactive Default Value: I |
| 4 | KSEC_NOCOMBO | Number(3,0) | SMALLINT NOT NULL |
Number of Security Combos
Default Value: 1 |
| 5 | KSEC_ALL_COMBO | Character(1) | VARCHAR2(1) NOT NULL |
All Combinations on a scroll
N=Specify Number of Combinations Y=Use All Combinations in Scroll Default Value: N |