EXT_ORG_IDPrompt Table: EXT_ORG_TBL
Default Value: %date
A=Active
I=Inactive
Default Value: A
E=External
I=Internal
Default Value: I
SCC_BRIN_VW(SQL View) |
Index Back |
|---|---|
BRINCode Table view |
| SELECT A.EXT_ORG_ID ,A.SCC_BRINCD_NLD , A.EFFDT , A.EFF_STATUS , A.DESCR100 , A.TELEPHN_PERM_AADSA , A.SCC_CIC_CD_NLD , A.SCC_BRINTP_NLD FROM PS_SCC_BRINCD_NLD A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
| 2 | SCC_BRINCD_NLD | Character(4) | VARCHAR2(4) NOT NULL | BRINcode |
| 3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 6 | TELEPHN_PERM_AADSA | Character(20) | VARCHAR2(20) NOT NULL | AADSAS Telephone |
| 7 | SCC_CIC_CD_NLD | Character(5) | VARCHAR2(5) NOT NULL | School Identification Code |
| 8 | SCC_BRINTP_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Brin Type
E=External I=Internal Default Value: I |