SSR_RI_OPCF_NLD(SQL Table) |
Index Back |
|---|---|
RIO Off Prog attribute setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: SSR_RI_RECNM_VW |
| 4 | SCC_CAF_ATTRIB_NM |
Character(20) | VARCHAR2(20) NOT NULL |
Common Attribute
Prompt Table: SSR_BR_ATRNM_VW |
| 5 | SSR_RI_AT_NAME_NLD |
Character(50) | VARCHAR2(50) NOT NULL | Common Attribute |
| 6 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 7 | SSR_RI_OPGRP_NLD | Character(4) | VARCHAR2(4) NOT NULL |
XML Node Group
N=Non Period Group P=Period Group Default Value: N |
| 8 | SSR_RI_ATRTYPE_NLD | Character(2) | VARCHAR2(2) NOT NULL |
RIO Attribute Type
/* 2021-10-13: fix for Bug-ID: 32929597 - RIOv3 */
Additional translate value 06.
01=Text 02=Enumeration 03=Date 04=Number 05=Boolean 06=Long text |