PSARCH_IDPSARCH_BATCHNUMEMPLIDEMPL_RCDALERT_IDSTART_DATEEND_DATEOPRIDORIG_OPRIDAA=Complete
AU=Accepted - Unrestricted
OP=Open
PC=Pending Correction
RA=Removed by Administrator
RW=Reviewed
TL_ALRT_RCP_HST(SQL Table) |
Index Back |
|---|---|
Alert RecipientsChild of TL_ALERTS Contains one row per recipient 'alerted' of a given alert. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | ALERT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Alert Criterion ID |
| 6 | START_DATE |
Date(10) | DATE | Start Date for Gen Standing PO |
| 7 | END_DATE |
Date(10) | DATE | End Date |
| 8 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 9 | ORIG_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 10 | ALERT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Alerts Status
AA=Complete AU=Accepted - Unrestricted OP=Open PC=Pending Correction RA=Removed by Administrator RW=Reviewed |
| 11 | DATETIME_UPDATED | DateTime(26) | TIMESTAMP | DateTime Updated |