EMPLIDPrompt Table: PERSON
CONTRACT_NUMEFFDTEFFSEQDefault Value: 100
Prompt Table: CNT_TYPE_VW_ESP
Y/N Table Edit
Default Value: N
CNT_DISBL_ESPVW(SQL View) |
Index Back |
|---|---|
Disabled Clauses Data ESP VWDisabled Contract Clauses Data ESP VW |
| SELECT A.EMPLID , A.CONTRACT_NUM , A.EFFDT , A.EFFSEQ , A.CONTRACT_TYPE , A.YWS_REG_DT_ESP , A.BONIF_AMOUNT_ESP , B.DISABLED , C.CARD_EXP_ENTTY_ESP FROM PS_WKF_CNT_TYP_ESP A LEFT OUTER JOIN PS_DISABILITY_ESP C ON A.EMPLID = C.EMPLID , PS_DISABILITY B WHERE A.EMPLID = B.EMPLID AND B.DISABLED = 'Y' AND C.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PS_DISABILITY_ESP ED WHERE ED.EMPLID = A.EMPLID AND ED.EFFDT <= A.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | CONTRACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Contract Type
Default Value: 100 Prompt Table: CNT_TYPE_VW_ESP |
| 6 | YWS_REG_DT_ESP | Date(10) | DATE | Warranty System Registratn Dt |
| 7 | BONIF_AMOUNT_ESP | Number(10,2) | DECIMAL(9,2) NOT NULL | Bonification Amount per Contract |
| 8 | DISABLED | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
Y/N Table Edit Default Value: N |
| 9 | CARD_EXP_ENTTY_ESP | Character(50) | VARCHAR2(50) NOT NULL | Card Expiration Date |