UNION_TBL_IND

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	UNION_CD	Character(3)	VARCHAR2(3) NOT NULL	Union Code Prompt Table: UNION_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	RECOGNIZED_IND	Character(1)	VARCHAR2(1) NOT NULL	This field is used for Union Recognition in the Union Table Page Y/N Table Edit Default Value: N
4	REG_UNION_IND	Character(1)	VARCHAR2(1) NOT NULL	This field is used for Rejistered Union in the Union Table Page Y/N Table Edit Default Value: N
5	MAJ_UNION_IND	Character(1)	VARCHAR2(1) NOT NULL	This field is used for Majority Union in the Union Table Page Y/N Table Edit Default Value: N
6	REGISTRATION_NUM	Character(8)	VARCHAR2(8) NOT NULL	Registration Number
7	REGISTRATION_DT	Date(10)	DATE	Registration Date
8	AFFILIATION_IND	Character(25)	VARCHAR2(25) NOT NULL	This field is used for Union Affiliation in the Union Table Page
9	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
10	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number