GPSC_ECPY_CIDTL(SQL Table) |
Index Back |
|---|---|
Element Clone CI ConfigurationElement Clone CI Configuration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPSC_PINTYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Element Type
AC=Accumulator AE=Absence Entitlement AT=Absence Take BR=Bracket DD=Deduction EG=Element Group ER=Earning FM=Formula PR=Process List SE=Section Prompt Table: GP_PIN_TYPE |
| 2 | BCNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Business Component Name (see PSBCDEFN).
Prompt Table: PSBCDEFN |
| 3 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 4 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: GPSC_ECPY_MSG_V |
| 5 | GPSC_ECPY_CPYOPT | Character(3) | VARCHAR2(3) NOT NULL |
Copy Options
AGN=1 - Auto Gen. Accumulators BTH=3 - Both Auto Gen. & Members MEM=2 - Member Elements NON=0 - None Default Value: NON |
| 6 | GPSC_VALID_CI | Character(1) | VARCHAR2(1) NOT NULL |
Valid CI?
Y/N Table Edit Default Value: Y |
| 7 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data |