GPSC_ECPY_CICOL(SQL Table) |
Index Back |
|---|---|
Element Copy - CI CollectionElement Copy - CI Collection |
| # | 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 | GPSC_ECPY_COLREQ | Character(1) | VARCHAR2(1) NOT NULL |
Collction Required to be considered during element copy
Y/N Table Edit Default Value: Y |
| 5 | GPSC_ECPY_MEMCPY | Character(1) | VARCHAR2(1) NOT NULL |
Used for Copying Members?
Y/N Table Edit Default Value: N |
| 6 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: Y |