GP_NRP_GLELM_VW

(SQL View)
Index Back

Packager View - GLTask Element

This non rules packager view will be used to move the GP_CHART_ELEM records from one database to another using the non rules packager.

SELECT COUNTRY ,CHART_FLD_CD ,SETID_FLD_CD ,PIN_SOVR_SETID_NUM + 50000000 ,ENTRY_TYPE_SOVR ,PIN_NUM + 50000000 FROM PS_GP_CHART_ELEM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: GP_COUNTRY_VW

2 CHART_FLD_CD Character(2) VARCHAR2(2) NOT NULL Chart Field code
17=AFFILIATE
18=AFFILIATE_INTRA1
19=AFFILIATE_INTRA2
20=ALTACCT
21=BUDGET_REF
22=CHARTFIELD1
23=CHARTFIELD2
24=CHARTFIELD3
25=CLASS_FLD
26=DEPTID_CF
27=FUND_CODE
28=OPERATING_UNIT
29=PRODUCT
30=PROGRAM_CODE
31=PROJECT_ID

Prompt Table: GP_CHART_PMT_VW

3 SETID_FLD_CD Character(2) VARCHAR2(2) NOT NULL Setid Field Code
01=SETID_DEPT
02=SETID_JOBCODE
03=SETID_LOCATION
4 PIN_SOVR_SETID_NUM Number(8,0) INTEGER NOT NULL Element number field
5 ENTRY_TYPE_SOVR Character(3) VARCHAR2(3) NOT NULL entry type sovr

Prompt Table: GP_ENT_TLCRT_VW

6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %RECNAME_EDIT