GP_PKG_CR_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 GP_PKG_ID Character(8) VARCHAR2(8) NOT NULL Field used for element packaging
4 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
5 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
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
8 ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge
9 ROW_COUNT2 Number(8,0) INTEGER NOT NULL Number of rows.
10 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
A=All Countries
C=Specific Country
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
12 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
13 GP_VERSION_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether version-based.
N=No
Y=Yes
14 OPTION_TYPE Character(1) VARCHAR2(1) NOT NULL Option Type
D=General Deduction
G=General Credit
O=Option
P=Program
W=Waive Option
15 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
16 PIN_MBR_NUM Number(8,0) INTEGER NOT NULL Element number field
17 GP_PKG_CRIT_SEQ Number(3,0) SMALLINT NOT NULL Field used for element packaging
18 GP_PKG_UPG_ACTION Character(1) VARCHAR2(1) NOT NULL Field used for element packaging
D=Delete
I=Informational Only
U=Upgrade
19 PKG_LNG_OPTN Character(1) VARCHAR2(1) NOT NULL Defines options available for exporting language-data.
A=All(Base&Related)
B=Base Only
R=Related Only
20 CRITERIA_CD Character(7) VARCHAR2(7) NOT NULL Criteria code
21 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field