GP_VER_REC_CHLD (SQL Table)	Index Back
Version Rule - Child Record This record is the child record in Versioning Rules. This defines records (data changes in which) cause GP_VERSION on the parent record to be blanked out.

GP_VER_REC_CHLD

(SQL Table)

Version Rule - Child Record

This record is the child record in Versioning Rules. This defines records (data changes in which) cause GP_VERSION on the parent record to be blanked out.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME_RULE_DFN Character(15) VARCHAR2(15) NOT NULL GP Rule Definition Record Name

2 RECNAME_CHILD Character(15) VARCHAR2(15) NOT NULL Record Name - Child
Prompt Table: GP_VER_REC_C_VW

3 EXP_REC_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether record needs to be exported.
Y/N Table Edit
Default Value: Y

4 RULE_REC_INBUF_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether record is in component buffer.
Y/N Table Edit
Default Value: Y

5 FIELDNAME_PIN_NUM Character(18) VARCHAR2(18) NOT NULL Fieldname on the record containing PIN Number that needs to be updated.
Default Value: PIN_NUM

6 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
N=Customer Data
S=Sample Data
Y=System Data

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME_RULE_DFN	Character(15)	VARCHAR2(15) NOT NULL	GP Rule Definition Record Name
2	RECNAME_CHILD	Character(15)	VARCHAR2(15) NOT NULL	Record Name - Child Prompt Table: GP_VER_REC_C_VW
3	EXP_REC_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether record needs to be exported. Y/N Table Edit Default Value: Y
4	RULE_REC_INBUF_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether record is in component buffer. Y/N Table Edit Default Value: Y
5	FIELDNAME_PIN_NUM	Character(18)	VARCHAR2(18) NOT NULL	Fieldname on the record containing PIN Number that needs to be updated. Default Value: PIN_NUM
6	DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type Code N=Customer Data S=Sample Data Y=System Data