GP_PKGMAP_VW (SQL View)	Index Back
Record Effdt type view This view stores the Element Type, Record name and Effective-date type of the records that need to be compared in order to produce the GP Rule Package Compare report.

GP_PKGMAP_VW

(SQL View)

Record Effdt type view

This view stores the Element Type, Record name and Effective-date type of the records that need to be compared in order to produce the GP Rule Package Compare report.

SELECT MAP4.PIN_TYPE , MAP4.RECNAME , MAP1.EFFDT_TYPE FROM PS_GP_PIN_FLD_MAP4 MAP4 , PS_GP_PIN_FLD_MAP1 MAP1 WHERE MAP4.RECNAME = MAP1.RECNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

3 EFFDT_TYPE Character(1) VARCHAR2(1) NOT NULL "Effective" Date Type. Indicates what type of date fields manages the effective date span on a given table. Used with managing triggers. Has codeset (XLAT values).
E=Effective Date
N=Not Effective Dated
S=Begin - End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Element Type
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
3	EFFDT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	"Effective" Date Type. Indicates what type of date fields manages the effective date span on a given table. Used with managing triggers. Has codeset (XLAT values). E=Effective Date N=Not Effective Dated S=Begin - End Date