PQ_REPTNG_TBL (SQL Table)	Index Back
PQ Releve Reporting Province of Quebec Reporting Identification. Introduced for Quebec Identification Number and Releve 1 form serial numbers.

PQ_REPTNG_TBL

(SQL Table)

PQ Releve Reporting

Province of Quebec Reporting Identification. Introduced for Quebec Identification Number and Releve 1 form serial numbers.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %DATE

3 QUEBEC_ID_NO Character(16) VARCHAR2(16) NOT NULL Quebec Identification Number

4 RELEVE_SERIAL_BEG Number(9,0) DECIMAL(9) NOT NULL Beginning RL-1 Serial No

5 RELEVE_SERIAL_END Number(9,0) DECIMAL(9) NOT NULL Ending RL-1 Serial No

6 RELEVE2_SERIAL_BEG Number(9,0) DECIMAL(9) NOT NULL Beginning RL-2 Serial No

7 RELEVE2_SERIAL_END Number(9,0) DECIMAL(9) NOT NULL Ending RL-2 Serial No

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %DATE
3	QUEBEC_ID_NO	Character(16)	VARCHAR2(16) NOT NULL	Quebec Identification Number
4	RELEVE_SERIAL_BEG	Number(9,0)	DECIMAL(9) NOT NULL	Beginning RL-1 Serial No
5	RELEVE_SERIAL_END	Number(9,0)	DECIMAL(9) NOT NULL	Ending RL-1 Serial No
6	RELEVE2_SERIAL_BEG	Number(9,0)	DECIMAL(9) NOT NULL	Beginning RL-2 Serial No
7	RELEVE2_SERIAL_END	Number(9,0)	DECIMAL(9) NOT NULL	Ending RL-2 Serial No