GP_PKG_COPY_AET

(SQL Table)
 Index Back

Agg Update State Record

Main State Record for Aggregate Update.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
6 PIN_NUM_LAST Number(8,0) INTEGER NOT NULL Last Used Element Number
7 GP_VERSION_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether version-based.
N=No
Y=Yes
8 GP_PKG_ID Character(8) VARCHAR2(8) NOT NULL Field used for element packaging
9 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
10 PIN_ELEM_NUM Number(8,0) INTEGER NOT NULL Element Number
11 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
12 PIN_MBR_NUM Number(8,0) INTEGER NOT NULL Element number field
13 PIN_NUM_TGT Number(8,0) INTEGER NOT NULL Element number [PIN] field
14 PIN_CODE Character(22) VARCHAR2(22) NOT NULL Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
15 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
17 PIN_MBR_NUM_TGT Number(9,0) DECIMAL(9) NOT NULL Element number [PIN] field
18 GP_PKG_UPG_ACTION Character(1) VARCHAR2(1) NOT NULL Field used for element packaging
D=Delete
I=Informational Only
U=Upgrade
19 GP_PKG_UPG_OPTN Character(1) VARCHAR2(1) NOT NULL Field used for element packaging
20 GP_PKG_ELEM_CMP_ST Character(1) VARCHAR2(1) NOT NULL Field used for element packaging
F=Failed
N=Compare Not Done
S=Successful
W=Warning
21 GP_PKG_NEW_PIN_FLG Character(1) VARCHAR2(1) NOT NULL Field used for element packaging
22 EFFDT Date(10) DATE Effective Date

Default Value: %date

23 EFFDT_L1 Date(10) DATE Effective Date L1
24 ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
25 SQL_ID Character(30) VARCHAR2(30) NOT NULL TL
26 STMT_TEXT_PART1 Character(100) VARCHAR2(100) NOT NULL Partial Statement Text 1
27 STMT_TEXT_PART2 Character(100) VARCHAR2(100) NOT NULL Partial Statement Text 2
28 STMT_TEXT_PART3 Character(100) VARCHAR2(100) NOT NULL Partial Statement Text 3
29 UPDATE_STATS_IND Character(1) VARCHAR2(1) NOT NULL Update Statistics
30 ERR_CNT Number(6,0) INTEGER NOT NULL Number of Compare Errors for a given package.
31 WARN_CNT Number(6,0) INTEGER NOT NULL Number of Compare Warnings for a given package.
32 UPG_W_ERR_IND Character(1) VARCHAR2(1) NOT NULL Decide whether to continue upgrade processing with errors.
33 UPG_W_WARN_IND Character(1) VARCHAR2(1) NOT NULL Decide whether to continue upgrade processing with warnings.
34 NEW_PIN_CNT Number(6,0) INTEGER NOT NULL Number of new elements for a given rule package.
35 PIN_NUM_INSTLN Number(8,0) INTEGER NOT NULL PIN Number value used to update the PIN_NUM_LAST field on INSTALLATION as part of upgrade procesing for new elements.
36 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
37 GP_CST_INSTALL_IND Character(1) VARCHAR2(1) NOT NULL Global Payroll Customer Installation Indicator
38 COMMENTS Long Character CLOB Comment