| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 2 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
PSRECDEFN_VW
|
| 3 |
TRGR_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Trigger Action
C=Changed
D=Deleted
N=New
|
| 4 |
TRGR_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Trigger level
F=Field
R=Record
Default Value: R
|
| 5 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
Default Value: A
|
| 6 |
TRGR_PROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Trigger Process
M=Batch Process
S=System
Default Value: M
|
| 7 |
ADMIN_FUNCTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table:
ADM_FUNCTN_TBL
|
| 8 |
EVENT_3CS_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
3Cs event ID
Prompt Table:
EVNT_3CS_VW
|
| 9 |
OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Method
Y/N Table Edit
Default Value: N
|
| 10 |
TRGR_OVRD_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Override Event
Prompt Table:
EVNT_3CS_VW
|
| 11 |
DUP_CHECK |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Keys Check
Y/N Table Edit
Default Value: Y
|
| 12 |
DUPCOMM_COMPL_COND |
Character(1) |
VARCHAR2(1) NOT NULL |
Communication Status
N=Not Completed
Y=Completed
|
| 13 |
DUPCOMM_VDATA_COND |
Character(1) |
VARCHAR2(1) NOT NULL |
Variable Data
N=Do Not Match
Y=Match
|
| 14 |
DUP_CHKLST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Checklist Check
Y/N Table Edit
Default Value: Y
|
| 15 |
DUPCHK_COMPL_COND |
Character(1) |
VARCHAR2(1) NOT NULL |
Checklist Status
C=Completed
I=Initiated
|
| 16 |
DUPCHK_VDATA_COND |
Character(1) |
VARCHAR2(1) NOT NULL |
Variable Data
N=Do Not Match
Y=Match
|