GP_PKG_CR_AET(SQL Table) |
Index Back |
---|---|
Agg Update State RecordMain 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 |