VC_CHK_AWARD_VW(SQL View) |
Index Back |
|---|---|
Variable Comp Chunking ViewVariable Comp Chunking View |
| SELECT VCA.EMPLID , VCA.EMPL_RCD , VCA.VC_PLAN_ID , VCA.VC_PAYOUT_PRD_ID , VCA.GB_GROUP_ID , PD.NAME FROM PS_VC_AWARD VCA , PS_PERSON_NAME PD WHERE VCA.EMPLID = PD.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | VC_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 4 | VC_PAYOUT_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 5 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |