RBQ_ADPTR_RL_VW

(SQL View)
 Index Back

Adapter Definition Role

BO Search Adapter Definition Role record

SELECT A.ADAPTER_ID ,A.ADPTRROLE_ID ,A.ROLE_SEQ_NBR ,%subrec(RBQ_ADPTRL_SBR,A) FROM %Table(RBQ_ADPTR_RL) A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ADAPTER_ID Character(20) VARCHAR2(20) NOT NULL Adapter ID
2 ADPTRROLE_ID Character(20) VARCHAR2(20) NOT NULL Adapter Role ID
3 ROLE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Role Sequence Number
4 FIELD_SEQ_NBR_1 Number(3,0) SMALLINT NOT NULL Field Sequence Number

Prompt Table: RB_DROPDOWN

5 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

Prompt Table: RB_DROPDOWN

6 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID

Prompt Table: RB_DROPDOWN

7 REL_TYPE_ID_2 Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID

Prompt Table: RB_DROPDOWN

8 APPLY_SECURITY Character(1) VARCHAR2(1) NOT NULL Apply Security flag

Y/N Table Edit

Default Value: N