EMPLIDCAL_RUN_IDC=Cancelled
I=InProcess
P=Processed
U=UnProcessed
Default Value: U
B=Batch
F=Benefits Administration
O=Online
S=Mass Trigger
U=Uncancel
V=Unsuspend
W=Time & Labor
Z=Time & Labor Feed
Default Value: O
GP_ITER_TRGR(SQL Table) |
Index Back |
|---|---|
Iterative TriggersThis contains the iterative triggers generated for a payee. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 3 | ITER_TRGR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Iterative Trigger Status
C=Cancelled I=InProcess P=Processed U=UnProcessed Default Value: U |
| 4 | TRGR_CREATE_TS | DateTime(26) | TIMESTAMP | Trigger Creation Timestamp |
| 5 | ITER_TRGR_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Iterative Trigger Source
B=Batch F=Benefits Administration O=Online S=Mass Trigger U=Uncancel V=Unsuspend W=Time & Labor Z=Time & Labor Feed Default Value: O |
| 6 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 7 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 8 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 9 | TRGR_FLD_VAL_CHAR | Character(25) | VARCHAR2(25) NOT NULL | Character Value |
| 10 | TRGR_FLD_VAL_DT | Date(10) | DATE | Date Value |
| 11 | TRGR_FLD_VAL_NUM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Numeric Value |