VC_GRP_RES_TBL

(SQL Table)
Index Back

VC Group Version Record

Variable Compensation: VC Group Version Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
2 VERSIONGBQDM Number(10,0) DECIMAL(10) NOT NULL Version Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 JOB_EFFDT Date(10) DATE Job Effective Date
6 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence