PROCESS_INSTANCECOMMON_IDSEQ_3CCG_SEQSCC_LETTER_CDO=Organization
P=Person
B=Publication
D=Document
E=E-Mail
F=Fax
L=Letter
P=Personal Contact
T=Telephone Call
W=Web
Y/N Table Edit
Default Value: N
SCC_CG_MERG_TBL(SQL Table) |
Index Back |
|---|---|
CommGen Merge TableThe CommGen merge table holds all instances of communications to be processed through XML Publisher. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COMMON_ID |
Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 3 | SEQ_3C |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | CG_SEQ |
Number(5,0) | INTEGER NOT NULL | CommGen Sequence |
| 5 | SCC_LETTER_CD |
Character(3) | VARCHAR2(3) NOT NULL | Letter Code |
| 6 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 7 | EMPLID_RELATED | Character(11) | VARCHAR2(11) NOT NULL | Related People ID |
| 8 | REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL | Report Name (see PSXPRPTDEFN). |
| 9 | TMPLDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Template ID (see PSXPTMPLDEFN). |
| 10 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 11 | SCC_CG_DS_ID | Number(5,0) | INTEGER NOT NULL | CommGen Sequence Number as high level key of CommGen Data Source definition. |
| 12 | SCC_COMM_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Method Used
B=Publication D=Document E=E-Mail F=Fax L=Letter P=Personal Contact T=Telephone Call W=Web |
| 13 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 14 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 16 | ORG_RECIPIENT | Character(50) | VARCHAR2(50) NOT NULL | Org Communication Recipient |
| 17 | NAME_RESULT_O_CNTC | Character(120) | VARCHAR2(120) NOT NULL | Name Result |
| 18 | NAME_RESULT_P_ADDR | Character(120) | VARCHAR2(120) NOT NULL | Name Result |
| 19 | NAME_RESULT_P_EXTR | Character(120) | VARCHAR2(120) NOT NULL | Name Result |
| 20 | NAME_RESULT_P_SAL | Character(120) | VARCHAR2(120) NOT NULL | Name Result |
| 21 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 22 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 23 | RELATIONSHIP_NBR | Number(2,0) | SMALLINT NOT NULL | Relationship Nbr |
| 24 | ORG_CONTACT | Number(4,0) | SMALLINT NOT NULL | Contact Nbr |
| 25 | ORG_DEPARTMENT | Number(3,0) | SMALLINT NOT NULL | Department Nbr |
| 26 | ORG_LOCATION | Number(3,0) | SMALLINT NOT NULL | Location Nbr |
| 27 | CG_LTRCD_ORDER | Number(5,0) | INTEGER NOT NULL | Letter Code Order |
| 28 | CG_SORT_ORDER | Number(5,0) | INTEGER NOT NULL | Sort Order |
| 29 | SCC_EMAIL_SND_ERR | Character(1) | VARCHAR2(1) NOT NULL |
Email Send Error
Y/N Table Edit Default Value: N |