VC_PLAN_IDPrompt Table: VC_PLAN_TBL
VC_PAYOUT_PRD_IDPrompt Table: VC_PAYPRD_TBL
GB_GROUP_IDPrompt Table: GB_GROUP_TBL
EMPLIDEMPL_RCDGP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
VC_PAY_FLG_VW(SQL View) |
Index Back |
|---|---|
Pay System Flag for VC AwardsView on JOB.PAY_SYSTEM_FLG for all EE in VC_AWARD. The join is done based on the period end date. |
| SELECT VA.VC_PLAN_ID ,VA.VC_PAYOUT_PRD_ID ,VA.GB_GROUP_ID ,VA.EMPLID ,VA.EMPL_RCD ,J.PAY_SYSTEM_FLG FROM PS_VC_PLAN_MEM VA , PS_VC_PAYPRD_TBL PP , PS_JOB J WHERE PP.VC_PLAN_ID = VA.VC_PLAN_ID AND PP.VC_PAYOUT_PRD_ID = VA.VC_PAYOUT_PRD_ID AND J.EMPLID = VA.EMPLID AND J.EMPL_RCD = VA.EMPL_RCD AND J.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID = J.EMPLID AND J1.EMPL_RCD = J.EMPL_RCD AND J1.EFFDT <= PP.PRD_END_DT ) AND J.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT = J.EFFDT ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL |
VC Plan ID
Prompt Table: VC_PLAN_TBL |
| 2 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Payout Period ID
Prompt Table: VC_PAYPRD_TBL |
| 3 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_TBL |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 6 | PAY_SYSTEM_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface |