SETIDDEPTIDTRIGGER_RECORDB=BUDGET
C=JOBCODE
D=DEFAULTS
J=JOB
P=POSITION_DATA
R=REQUISITION
T=DEPARTMENT
TIME_STAMPI=In Process
N=Not Processed
Y=Processed
Default Value: N
BUDGET_TRIGGER(SQL Table) |
Index Back |
|---|---|
Encumbrance TriggerVarious online events from Job, Position, Contract, Department Budgets, Department Defaults, and Job Requisitions cause a pre-encumbrance or encumbrance to be processed. Whenever one of the specific on-line events occur a row will be written to the Record. These trigers are then used as input for the encumbrance batch processes. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 3 | POSITION_POOL_ID | Character(3) | VARCHAR2(3) NOT NULL | Position Pool ID |
| 4 | TRIGGER_RECORD |
Character(1) | VARCHAR2(1) NOT NULL |
Triggered From
B=BUDGET C=JOBCODE D=DEFAULTS J=JOB P=POSITION_DATA R=REQUISITION T=DEPARTMENT |
| 5 | TIME_STAMP |
DateTime(26) | TIMESTAMP | Time Stamp |
| 6 | PROCESSED | Character(1) | VARCHAR2(1) NOT NULL |
Processed?
I=In Process N=Not Processed Y=Processed Default Value: N |