GPMY_CP8A_HDR

(SQL Table)
Index Back

Header For CP8A

Header F

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON_NAME

2 GPMY_CONTRIB_YEAR Number(4,0) SMALLINT NOT NULL Contribution Year
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 GPMY_TAX_NBR Character(12) VARCHAR2(12) NOT NULL GPMY_TAX_NBR
5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
6 HIRE_DT Date(10) DATE First Start Date
7 TERMINATION_DT Date(10) DATE Termination Date
8 SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number
9 GPMY_ISSUE_STATUS Character(1) VARCHAR2(1) NOT NULL Issue Status for CP8A

Y/N Table Edit

Default Value: N

10 GPMY_REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier
11 CREATION_DT Date(10) DATE Creation Date