EMPLIDCAL_RUN_IDTRGR_CREATE_TSB=Batch
F=Benefits Administration
O=Online
S=Mass Trigger
U=Uncancel
V=Unsuspend
W=Time & Labor
Z=Time & Labor Feed
C=Cancelled
I=InProcess
P=Processed
U=UnProcessed
Prompt Table: GP_TRGSTAT_I_VW
GP_ITER_TRGR_VW(SQL View) |
Index Back |
|---|---|
Iterative Trgrs(Not Cancelled)This view selects iterative triggers that are not canceled. |
| SELECT EMPLID , CAL_RUN_ID , TRGR_CREATE_TS , ITER_TRGR_SRC , ITER_TRGR_STATUS , RECNAME , FIELDNAME , TRGR_FLD_VAL_CHAR , TRGR_FLD_VAL_DT , TRGR_FLD_VAL_NUM , COUNTRY FROM PS_GP_ITER_TRGR WHERE ITER_TRGR_STATUS <> 'C' |
| # | 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 | TRGR_CREATE_TS |
DateTime(26) | TIMESTAMP | Trigger Creation Timestamp |
| 4 | 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 |
| 5 | ITER_TRGR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Iterative Trigger Status
C=Cancelled I=InProcess P=Processed U=UnProcessed Prompt Table: GP_TRGSTAT_I_VW |
| 6 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 7 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 8 | TRGR_FLD_VAL_CHAR | Character(25) | VARCHAR2(25) NOT NULL | Character Value |
| 9 | TRGR_FLD_VAL_DT | Date(10) | DATE | Date Value |
| 10 | TRGR_FLD_VAL_NUM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Numeric Value |
| 11 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |