GP_ABS_MED_CERT

#	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	TRANSACTION_NBR	Number(15,0)	DECIMAL(15) NOT NULL	08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence Default Value: 1
6	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
7	GP_ABS_SEC_VAL_FLG	Date(10)	DATE	Section Validation Flag
8	GP_ABS_MDCRT_ODUE	Date(10)	DATE	Original due date Default Value: %date
9	GP_ABS_MDCRT_EDUE	Date(10)	DATE	Extended due date Default Value: %date
10	GP_ABS_MDCRT_IRCV	Date(10)	DATE	Incomplete received date Default Value: %date
11	GP_ABS_MDCRT_CRCV	Date(10)	DATE	Complete received date Default Value: %date
12	GP_ABS_MDCRT_CMPLT	Character(1)	VARCHAR2(1) NOT NULL	Medical certification completed
13	GP_ABS_MDCRT_CHRNC	Character(1)	VARCHAR2(1) NOT NULL	Chronic condition
14	GP_ABS_MDCRT_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Frequency O=One Time R=Recurrent
15	GP_ABS_MDCRT_DUR	Number(4,0)	SMALLINT NOT NULL	Duration
16	GP_ABS_MDCRT_MISC	Character(30)	VARCHAR2(30) NOT NULL	Miscellaneous
17	GP_ABS_MDCRT_PHYS	Character(30)	VARCHAR2(30) NOT NULL	Physician name
18	GP_ABS_MDCRT_DTFM	Date(10)	DATE	Certification date from Default Value: %date
19	GP_ABS_MDCRT_DTTO	Date(10)	DATE	Certification date to Default Value: %date