GPSC_ECPY_CIFLD(SQL Table) |
Index Back |
|---|---|
Element Copy - Collection FldsElement Copy - CI Collection Fields |
| # | 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).
Default Value: GPSC_ECPY_CIDTL.BCNAME |
| 3 | BCITEMNAME |
Character(30) | VARCHAR2(30) NOT NULL |
BC Item Logical Name
Prompt Table: GPSC_ECPYCOL_VW |
| 4 | ITEMNAME |
Character(30) | VARCHAR2(30) NOT NULL | Item Name |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 7 | GPSC_ECPY_ORGSEQ | Number(6,0) | INTEGER NOT NULL | Original Sequence No. |
| 8 | GPSC_ECPY_REVSEQ | Number(6,0) | INTEGER NOT NULL | Revised Sequence No. |
| 9 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data |