ORG_RCP_USAGEPrompt Table: SCC_ORG_USAGE
ORG_RCP_USAGE_ORDRCTC=Contact Type
DPT=Department Type
LOC=Location Type
ALL=All
PRE=Preferred
PRI=Primary
Default Value: ALL
Prompt Table: ORG_CNT_TYP_TBL
SCC_ORGUSG_ORDR(SQL Table) |
Index Back |
|---|---|
Org Recipient Usage OrderTableThis table stores the usage order set up for Organization Communications. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ORG_RCP_USAGE |
Character(10) | VARCHAR2(10) NOT NULL |
Organization Recipient Usage
Prompt Table: SCC_ORG_USAGE |
| 2 | ORG_RCP_USAGE_ORDR |
Number(4,0) | SMALLINT NOT NULL | Org recipient usage order |
| 3 | ORG_RCP_USAGE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Org Recipient Usage Type
CTC=Contact Type DPT=Department Type LOC=Location Type |
| 4 | ORG_RCP_OPT | Character(3) | VARCHAR2(3) NOT NULL |
Org Recipient Option
ALL=All PRE=Preferred PRI=Primary Default Value: ALL |
| 5 | ORG_CONTACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Contact Type
Prompt Table: ORG_CNT_TYP_TBL |