IMMUNIZATIONEFFDTDefault Value: %date
CRITERIA_SEQIMMUN_CRIT_VW(SQL View) |
Index Back |
|---|---|
Immunization Criteria ViewIMMUNIZATN_CRIT stores information about each criteria. |
| SELECT DISTINCT a.immunization , a.effdt , a.criteria_seq , a.descr FROM PS_IMMUN_CRIT_TMPL a , ps_immunizatn_tbl b WHERE a.immunization = b.immunization AND b.eff_status = 'A' AND a.EFFDT = ( SELECT MAX(EFFDT) FROM PS_IMMUN_CRIT_TMPL c WHERE a.immunization = c.immunization AND C.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IMMUNIZATION |
Character(5) | VARCHAR2(5) NOT NULL | Immunization |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | CRITERIA_SEQ |
Number(2,0) | SMALLINT NOT NULL | Criteria Nbr |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |